Save record to 2 tables on one click

[chin1383]

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

[kennejd]

These tables should be related by a customerId (foreign field in the orders table). That way if you make a change to the customer table, you don't have to change anything in the orders table. You shouldn't store the customer name in the orders table unless it's something you want for historical puposes...to store the name of the customer at the time of the order.

If you still think it's important to update the customer name in the orders table, you could create an update query and run it with your save button.