The table at the remote location is always going to be out of date. Yes, I will add a time stamp.
W.
>Winn,
>
>How would you know which one is outdated? Is there a timestamp on each record?
>
>>Hi All,
>> I have two tables that are supposed to be identical. One is at the home office and the other at a remote location. I was thinking of comparing each record one by one, but I was hoping there was an easier way. Has anyone had to compare two tables before and update the one that is outdated?
>>Thanks,
Winn Pauley