Bob: Let me tell you how I have done this when faced with having to delete
alot of data. As you say, bring it into an RBase table. Add an extra
column, like tmpFlag Text 1. Probably build an index on the order#. Then
do
an update:
UPDATE importtable SET tmpFlag = 'x' FROM importtable t1,
yourordertable t2 +
WHERE t1.order# = t2.order#
Then you can append to your Archive table where tmpFlag is null.
Karen
> What makes this difficult is that the unique index on the foreign data
> base is order number, but it is not numeric, it is alphanumeric. So an
> order could be OR123456 and the next order could be AB123456.
>
> (I did not create this database and cannot change this logic) If this
> was a numeric field, I could find the maxium order number in the Rbase table
> and append any records from the ODBC tables with a larger order number.
> However this will not work with an alphanumeric field.
>
>
>
> Any thoughts of an efficient method to obtain only new records?
>
>
