Problem of adding details to a record in a table

[rave1991]

I have created a database using access 2007. There is a one table called order and primary key is orderID and tpe is Auto number. Order(OrderID,Date, Time, CustomerID). There is another table for Pizza(PizzaId,PizzaName,PizzaPrice) PizzaID is a text type we include that. one customer can place a order and that order can have many pizzas.One to Many relationship. So I created a table pizzaOrder(OrderId,PizzaId,Amount).I have created a form.But customer can only place one pizza to his current order.i add a button.but when it clicked new order comes.customer can not add extra pizzas to his current order.I can`t implement this using forms. So please give me solution I want to add many pizzaID s to one Order.when customer can have ability to add pizzas using button like things. i have used toggle buttons and use a vba code to select pizzas. But customer can’t add many pizzas to his order. cutomer can only add one pizza to his order. So guide me to the correct way. I need a way that cutomer can add many pizza ids to his current order.



When a customer want to add pizza for the second time new record must be added to the table PizzaOrder but his current order must be automatically add to the OrderID. I want to know how to implement this this by using button like thng.

[RuralGuy]

You would normally deal with this 1:M relationship with a Form/SubForm arrangement. Is that what you are doing?

[rave1991]

yeah for example i customer add pizza to his current order 4.then he click add new pizza and add new pizza to his current order and pizzaOrder table must be updated with 2 records but same Order Id.we can manually add details but i want to know how to do this by using button.records must be cleard new record must be added to the PIzzaOrder table but with current order no.

[RuralGuy]

The LinkChild/MasterFields properties of the SubFormControl will take care of this issue if set to the OrderID field.

[rave1991]

can you please explain it further.

[RuralGuy]

Do you have anything in those two properties of the SubFormControl?

[rave1991]

i don`t understand i will give you a example.in order table orderId is the primary key and it is an autonumber..so there is no duplicates in thier. next there is table called pizza pizzaId is the primary key.there are three pizzas in there PizzaId s are E1232,C1942,F4567. but for Order no 4 customer wants to add these three pizzas to his to his OrderID 4. so i created a table intermediate table PIZZAORDER two attributes in there are OrderId and PizzaId. so
OrderId pizzaid
4 E1232
4 C1942
4 F4567

so like this how do i add this using a form.also i mention i have included customer ID also.i have created a form that customer can choose his given customer id from the combo box then he can click the relevant button and add one pizza to his current orderID 4.then i included add new record button to form.so when customer click that button new order Id 5 will create.he can`t add many pizzas to his current order 4.so i want to know how to implement this

[RuralGuy]

If the SubForm has the PIZZAORDER as its RecordSource and the OrderTable is the RecordSource of the MainForm and the LinkChild/MasterFields properties of the SubFormControl are set to OrderID, then everything you want to happen will happen and you do not need the extra buttons if the SubForm is in Datasheet View.