Adding multiple lines to an order

[Guest]

I have an order taking form that populates from a query that is based on 3 tables (client, orders, and orderdetails). I have set the option for order entry but when I enter new records through the form it does not attach the order number to any of the orderdetails records, nor does it attach the customer ID to the orders record. Is this something that I will need to do programmatically or do I have my relationships set incorrectly?

Thank

 

[Mike Painter]

I have an order taking form that populates from a query that is based on 3

tables (client, orders, and orderdetails). I have set the option for order
entry but when I enter new records through the form it does not attach the
order number to any of the orderdetails records, nor does it attach the
customer ID to the orders record. Is this something that I will need to do
programmatically or do I have my relationships set incorrectly?The form should have a subform that adds the details. Access will try to
link the master and child but you may have to do it manually. You don't
actually have to establish the relationship before hand.
Their should be a customer ID field in the orders table. That would fill the
name address etc in the master part of the form, or if you have another
subform, fill it there.
You have to add that.
There is no need for the Customer ID to be on the detail records although I
admit to having placed placing it there in the past. (Leftover from a non
relational database and sloooow computers which we though were fast.)