Looking for a little help,
I have an app that is running at two locations. Both locations are inputting and changing customer data. At the end of the night a data transfer takes place placing a copy of each customer table on each computer i.e. computer A gets computer B's table and computer B gets computer A's. My problem is how do I merge the two tables looking for new and updated records without duplicating anyone's information. If computer A changes Sally's information I want the changes reflected into computer B's. Hope I am clear enough. Thanks for the help in advance.

Bill