text display in report

[Tyler]

Before I ask my problem:

I have two tables, one of which contains a list of landscape features
and their associated descriptions as well as a unique id for each. I
have a Main table in which there is a field called Feature_01. On the
form a person selects a landscape feature in the Feature_01 field and
it is displayed. On my report I can get the feature name to be
displayed but I cannot get the associated description to show up.

When i created an unbound text box and used Feature_01 as the control
the unique id for the feature showed up. I would like the description
to show up. When i made some adjustments I tried to make it specific
to the description a pop up box came and said "Enter Parameter......"
which is unhelpful in creating a report.

Any help on me being able to link the information would be great.

thanks

 

[Marshall Barton]

I have two tables, one of which contains a list of landscape features
and their associated descriptions as well as a unique id for each. I
have a Main table in which there is a field called Feature_01. On the
form a person selects a landscape feature in the Feature_01 field and
it is displayed. On my report I can get the feature name to be
displayed but I cannot get the associated description to show up.

When i created an unbound text box and used Feature_01 as the control
the unique id for the feature showed up. I would like the description
to show up. When i made some adjustments I tried to make it specific
to the description a pop up box came and said "Enter Parameter......"
which is unhelpful in creating a report.

The report's Record Soure query needs to include both table
so the description field is available to be used in a report
text box.

 

[Tyler]

how would I do this?