I have this 3 tables (USR-User Data Entry table, ITR-Retail Transaction table and SJ-Sales Journal table).
So my problem is I can't get the right relationship connection between this 3 tables on how to update the record on the SJ table. The first connection is good but it only update the record on the ITR table. Is it possible to update two tables (ITR and SJ) on the same time with the same ID (record).
Example: I made a retail transaction. The customer pay only 50% of the total amount and on the next day the customer return to pay for the remaining balance. So I have to update the record of this customer in the ITR table and on the same time it should also update the record on the SJ table of the same ID(record).