Look-Up Field is displaying # in temp Table 1

[bethabernathy]

Hi There: I have a temporary table that is being generated from a number of append queries. All is working great, but the two look-up fields in the table are appending as their number value (i.e. ProbableinjuryID = 1). When I look at the table I can see that the fields properties are numbers. Anyway, I thought I could change the field properties to that of the original table and make it a combo box, but then the append queries don't work.

Long story short, I want my report to reflect the data in the look-up rather than the value of the field. So in my report I have the field:

ProbableinjuryID

reporting as 1, 2, 3, etc.

Is there a way to get the field to report the data?

Thanks,
Beth

 

[JerryDennison]

In the report's underlying recordsource (based on the temporary table) add the other tables that contain the rest of the lookup information. Link these tables to the temp table using the appropriate linking field(s). You may now add the linked tables more descriptive fields to the QBE grid and have them available for your report.

 

[bethabernathy]

Hi Jerry: Perfect!!! Thank you!!!!

Beth

 

[JerryDennison]

You're welcome.