Use same field multiple times in query

[laxster]

Hi all,

I have a table in which multiple item numbers are stored in the same record. I am trying to build a query in which the item descriptions are pulled from a different table, but can still tie together the item # and the description multiple times on the same record for different item #s. For example, one record will have Item #1, Item #2, Item #3, Item #4, and each one of those items should be tied to a description.

Is this possible to do?

I am thinking I need to use some criteria to get the query to do this, but I'm running into trouble.

Any thoughts?

 

[pbaldy]

Is it too late to fix the design? Having items as fields is a big normalization problem. The solution to your problem if you choose to keep that design is to join to the descriptions table 4 times.