Add/Edit/Delete the same record in two tables at the same time

[LeviP]

Hi guys
I'm trying to create/modify/delete the same record in two tables at the same time.
This is a sales invoice + movements of the products

Example I have these tables:
................................................
Table "OrderHeader"
Fields "OrderHeaderID, Date, CustomerID"
Here it is kept well

Table "OrderDetail"
Fields "OrderDetailID, OrderHeaderID, ProductID, Qty, Price"
Here it is kept well

Table "Movements"
Fields "MovementID, ProductID, ProductName, Stock, Price"
But in this table I don't know how to do it

regards