I have Table1 and Table2
tblID1 is a string in Table1 and tblID2 in Table2 is a string nchar10
tblID1 in Table1 needs to correspond with all the tblID2 values in Table2. Is there a way to link the values in Table1 to Table2 if they change in Table1?
For example, if I create a record in Table1 with tblID1 = 1, then tblID2 = 1. However if I change ID1 = 5, then tblID2 = 5
Is there a way to do that?