Update, I have worked it out and it works!!
I have had to modify my table fields and relationships (just a little)
Customer Table : New Y/N, Merged Y/N, Inactive Y/N
Account Numbers Table: Customer ID, Account No
Merged records table: Merge ID, Customer Merged ID, New Primary Customer ID...