>Help please
>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
I suggest you either -
a) make a log file at each location, recording all changes , additions and deletions. This can then be 're-played' to update the other database.
or
b) add a timestamp field to each record which gets set whenever the record is updated in any way. This can then be used at the destination to identify which records have changed.