Originally Posted by
June7
Correct section. Your forms are not in proper arrangement. You have three tables.
Orders
Items
OrderItems
this table relates orders and items.
Orders should BE the main form. OrderItems should be the subform, probably in Datasheet view. The subform container control Master/Child link properties should be the OrderID primary and foreign keys of the two tables. This will synchronize the child records in OrderItems with the Order records. Items table can be the source of rows in a combobox to select items to associate with an order.