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