Query shows Data but report shows ID #

[CTQE]

Hello All,

Some back ground on my DB:
1 Main Table fed by many sub tables.
The sub tables are all lookup tables to create drop down boxes for the main table.
For the sub tables, column 1 is the ID# & the second column is the actual data.

I made sure the bound column was 2.

When running the query, the data is in the output but in the report it lists the ID#.

Please help.

 

[boblarson]

You do not want to have lookups defined at table level. You use them with combo's and listboxes at FORM level but not table level. Get rid of the lookups in the tables (see here for how) and then do it the right way and in your report you include the lookup tables in the record source query and select the DESCRIPTION fields instead of the ID field to display (linking the tables together on their PK/FK fields).

And see here why lookups at table level are EVIL.