Save records in 2 tables at one click

[china1383]

Hello Experts,

How should I save the record in 2 different tables on one button click? Here is what I am trying to do:

I have 2 tables Customer and Orders

Customer-à CID CNAME CNUM
Orders----à OID ONAME CID CNAME

I have designed a form using ‘Customer’ table and created a ‘Save’ button. Now if I enter the fields CID CNAME from customer form and click on save button, the same values (CID CNAME) should get updated in Orders table as well.

Any suggestions are greatly appreciated.

Regards,
Chinmay

 

[Mr Smin]

You can avoid storing CNAME in both tables. Only CID needs to be in both.
After that, you could use a main form for Customer and a subform to show all orders for that customer. The subform wizard should get you started.