Need Help Very Confused

[Deonh]

Hello All

i have created a a database with products and locations and customer orders

the problem im having is i created a form with my customer name on it and a query between orders and products. i made a form from my query and brought it in as a sub-form on my customer form so i can put orders with my customers

the problem is when i add product on my sub form witch is linked to my customer form it does not link the products to my customer and when i go to a new record and come back it don't show any product for that customer i am attaching my database to show where i am and maybe to see where i am going wrong

 

[bob fitz]

IMHO, What you need is a form based on your orders table, containing a sub form llinked to your order details table.