LIST1 contains parent records
LIST2 contains child records
LIST1 & LIST2 are connected
LIST3 is a list that contains several fields from enterprise systems but the DealID field would be shared across all three.
My question is what woul be the best way to connect the data from LIST3 to LIST1 & LIST2 after it is re-created each time...