Creating a linked form on Access 2003

[melsquared]

Hi, I'm new to Access, but I am doing this for a work project. We are linking Customers to their Orders, so a one-to-many relationship. I made a table for Customer, including a primary key automatically created by Access (Customer ID), and various fields for their contact information, address, email, phone, etc. Then I made an Order table, with an automated primary key (Order ID), with fields for the product details. Then I linked the CustomerID to the order form by linking SELECT Customer.CustomerID FROM Customer.



All of this works perfectly on a table, but when I try to make a linked form, it shows it working perfectly for all previous entries, but not for new entries. Every new entry I put in is not linked to the customer, but just goes straight to the general order form, which is not what I want.

Any help, or words of advice?

Thank you.

[ranman256]

what is a linked form?
if you mean parent/child, then you CANNOT enter orders until you save the parent master record.
if you enter a new client and dont save the data, you cant enter the orders. Once you save the master record, it creates the auto ID.
once the ID is created THEN you can enter orders.

[melsquared]

Yes, I believe I mean parent/child, because the Customers is the main form and the Orders is linked to that.
Do I need to save the master record separately? It works perfectly when I add data to the table, it shows it as previous entries on the form form. But when I add a new on the form, then it doesn't save it as a child of the customer it should be attached to. It just saves it directly to Orders, unconnected.