AnsweredAssumed Answered

Connect 3-tables

Question asked by kingicen on Aug 16, 2018
Latest reply on Aug 21, 2018 by philmodjunk

I have this 3 tables (USR-User Data Entry table, ITR-Retail Transaction table and SJ-Sales Journal table).

Screen Shot 2018-08-15 at 3.05.13 PM.png

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).