Hi
my Data Base consist of the following tables:
Customers,Products, Suppliers,Orders,Orders_Details
the relationships are as follow
Customers-Orders ( one to Many relational field customer-id)
Supplier-Products(one to many relational field supplier-id)
orders-orders_Details( one to many relational field order-id)
I have the information of my orders divided in 2 tables (orders, orders-details). the fields of the orders tables are the Order-id customer-id, Date. the Fields of the orders-details
are ID(primary key),Order-ID, customer-id,Product-id,quantity, in this table each product from each order gets his own record.
I'm trying to build a simple form, in order to introduce new orders,when i do the form the form displays the information correctly, but when i try to add a new record the customer-id of the form(orders) and the customer-id of the sub-form(Orders-details) doesn't match, allowing me to introduce details to a different customer