displaying text in a report

[Tyler]

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.
i did receive advice in that I should change the record source for the
report. The report record source contains both the main query that
the form is based on as well as the table containing the feature
descriptions> I still cannot link the two together to display the
description i keep coming up with the unique ID

 

[Duane Hookom]

"I still cannot link the two together to display the description" Why? Can't
you join the two based on the ID field from the table containing the
description field? This should join to the Feature_01 field.

It seems that you have used evil lookup fields
http://www.mvps.org/access/lookupfields.htm and possibly have un-normalized
tables. Do you have Feature_02 and Feature_03 as fields? If so, do you
understand why this might not be a good structure?

 

[Tyler]

"I still cannot link the two together to display the description" Why? Can't
you join the two based on the ID field from the table containing the
description field? This should join to the Feature_01 field.

It seems that you have used evil lookup fieldshttp://www.mvps.org/access/lookupfields.htmand possibly have un-normalized
tables. Do you have Feature_02 and Feature_03 as fields? If so, do you
understand why this might not be a good structure?

Unfortunately I dont' understand, I am still in the process of
learning Microsoft Access. I do have Feature_02 and Feature_03 etc. I
thought this would be easy to do because initially i was able to do it
using combo boxes but then read that was not such a good idea.

 

[Duane Hookom]

Your report's record source query must contain the table with the desired
description field. Join the tables as I mentioned previously.