hi and thanks
answer of Eirikur's questions
1. Do you have some sample data we can use?
I'm sorry no I do not have
2. Does the code have to detect missing rows?
no code is not detected missing rows(table 3 row sending to our hardware for see this information on LED board)
3. If 2 = Yes, in which tables?
4. Can you also answer Phil's questions?
answer of Phil's questions
a) Do not have a matching row in table one, or?
no do not matching row in table 1, [BedCode] is unique
b) Have one or more columns whose value is different.
i need if field of [FirstName] [LastName] [BeneficiaryName] [ReferralDate] and age is changed
i copy row to table 3