I have one access database with certain customer information and another with other information relating to the same customer. i.e. one database has their names and addresses and other vital information and the other has just their names and adresses and their customer number. Is there a simple way of adding the customer number without doing it manually.
I would need to compare first name,last name,address between each database and then add the separate number.
This thread is now locked and can not be replied to.