Query Relationship Help

[chewy]

I have two tables that you can see from the attachment. What I need to do is have a query that looks up the info from the two tables and returns the itemDesc, the AmtonHand and the ReorderAmt. I just dont know how to set the SQL up for this or if I am having problems because of my relationships.

I can give more details if this is too vague.

 

[Mark Wild]

Chewy,

I think the problem is coming due to your tables structure. You need to look at how you've normalised your tables.

THe linked description fields are a rather hardous way of linking the data. It also means that the full description of the item is going to be recorded more than once.

Your table structure oin the TblItemInfo looks ok, but in the other table, replace description with with ID number for the item, making it the foreign key.

You can then link these two fields and the relationship will allow you to pull through the description when you need it.

Psot back if an amended table structure doesn't help you sort your query.