>Hi everybody,
>
>I'm working on DataEntry application at this moment. One of the regimes is "Download new version of Lookup tables". These tables are part of Lookups database and only few really change.
>
>So, somebody will put these two or free tables in Download directory of DataEntry. These tables have a link to a DataBase. I guess, I can not just copy tables from this directory to Lookups directory, because I would have problems with links.
>
>One solution would be to open old table exclusively, zap and append from the new (if I would be able to open it without its Database). I'm wondering, is there another "back door" way? Fixing database on the fly (with low-level functions)?
>
>Appreciate your guidance.
Hi Nadya,
You might try to open both tables, SCAN through the new source table and go through the target table completely replacing the records one-by-one with SCATTER/GATHER. New lookup tables typically contain more records, however if the target table will have more records than the new source you may just delete the rest.
This way you will reuse the existing amount of records.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison