Too many lookup tables

[LynneAOG]

I receive a daily modification file with 41 coded fields. In order to run reports with the code descriptions I have to create a "tangled" mess of joins. How can I combine all the codes into a single lookup table?

 

[BattleDroid42]

This is just a hunch based on the information you provided so far, but it sounds like you might need to create a master cross reference table listing all the codes and their descriptions and join your code records to it.

Cheers,
BD42

 

[LynneAOG]

I already guessed that I need a cross-reference table, but I'm not sure how to access it from the master table.

 

[PHV]

I'm not sure how to access it from the master table
Take a look at JOIN in your Jet SQL help file.
you may also take a look at Relationships, Primary Key, Foreign Key.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244