If that is always case, and depending on the size of the tables involved, it might be easiest to simply copy the entire table to the remote location.
>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,
Steve Gibson