I have 2 of the exact databases with the same fields but a different amount of records for customer info.
The main database has all customer records and the second databse has only customer records pertianing to one location.
Both databases are housed in 2 seperate locations.
I know this sounds redundant but we need to keep serperate databases for checks and balances.
What I need to do is every month compare changes and then update.
We need to compare the records that have been updated in database 2 (records specific to that location)with database 1(the main database)
We need to know what changes have happened per record because we have to ensure we have hard copy documentation to support the changes from the users of database 2.
I would loke some indicator that says records compared and match exactly and then compared records and these are the changes.
Can you please help as soon as possible!
Thanks so much