Report shows number instead of lookup item

[jackmac]

Hi all,

Been working on a database for a few weeks and had some awesome help (thanks David!!). I'm nearly there now, just got one thing before I go 'live'.

The database has two tables (more but you get the idea). One of the tables has a set of choices (product types such as window handles, screws, hardware etc.) the other table has the overall database. When the user picks from the input form, the drop down box shows the 'types' list. When they make their choice, it writes their choice into a product group' field in the main database. Unfortunately when I create a report from this table, instead of getting say 'screws' showing as the group, it shows '2', 'window handles' is '3'.

I can see that the overall table gets the values as a numerical value from the 'types' table. How can I make it show the product group and not the item number as it appears to be showing?

Any help, much appreciated.

TIA

Jack

 

[jjturner]

Hi Jack,

That's a good sign you're using the "Foreign Key" values (numbers) to populate your main data table.

When it comes time to display your data in a report or form, then you'll need to reconnect ("join") the 'Foreign Key' field in your main data table to the corresponding 'Primary Key' in your "lookup table" in a query.

So whatever RecordSource you're using for your report at the moment needs to be switched to this query which will provide the Names for your types.

Hope this makes some sense!

Regards,
John