>Hi Larry:
>
>D:\Newschd\Schd.dbf has all of my new addtional fields.
>
>D:\Schedule\Schd.dbf has all of my live data records.
>
>I would like to move all Schedule\Schd.dbf records into D:\Newschd\Schd.dbf table. Will scan work for this also?
Yes you can brute force it. Scan table1, seek on table2, if exist, replace values if needed. If it doesn't exist, insert a new record.
Note: Make sure the new fields allow NULL values or have default values assigned. If you attempt to add a new record from table1. the table2 fields without values will throw an error, otherwise.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao