Query Problems?

[DS]

I have two Subforms on a page. The first one is linked to the main
form, the second Subform is linked to the first Subform. This basically
works fine. The First Form is ORDERS, The Second is PRODUCTS, and the
Third is MODS. The problem is that whenever I go back to a record in
Products it gives me all of the Mods that have ever been selected for
that Product, not just for that particular order. I looked at the
Northwinds example, but unfortuately I have an extra Table involved, I
tried playing with my Queries but that didn't work either. I tried
adding the Order number to the MODS, but that didn't work either.

This is the Table layout, Perhaps something wrong there?

ORDER TABLE Order ID
to
ORDER DETAIL TABLE Order ID, Product ID
to
PRODUCTS TABLE Product ID
to
MOD DETAIL TABLE Product ID, Mod ID
to
MODS TABLE Mod ID

Thanks,
DS

 

[Guest]

You list 4 tables but say that you only have three forms. What are you doing
with the OrderDetail table? How does Products work into it? What are your
primary and foreign keys for each of the tables?