Hi, can you help me to solve this problem?
I have 2 tables
MasterTable : Order
Fields =
OrderID (PK)
TotalOrder
DetailTable: Payment
Fields =
PaymentID (PK)
Total Order
OrderID (FK)
How can I pass the value of TotalOrder from MasterTable to TotalOrder in DetailTable.