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?

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.