query with multiple lookups in normalized database 1

[dbero]

I have a table that has multiple data elements in it that require a lookup table. For example two fields may be seat color and paint color 2. each field has a number in it, say 1 and 2, so i need to relate both fields to a lookup table to find out what 1 is and what 2 is. But when i create multiple relationships to a single lookup field, it fails. Can anybody help with this normalized database query?

Thank you much!

 

[dhookom]

You might think this is normalized but I'm sure there are arguments against.

You can include the lookup table twice in the query design and link a copy to each color field.

Duane
Hook'D on Access
MS Access MVP

 

[dbero]

Oh,so you're saying in the design, include the lookup table multiple times. I never thought of that, thank you. I was thinking I may need to run a seperate query for each lookup item, then bring the data together wth a cumulative query. I will give this a try. Thank you veyr much!