updating old data

[mireille]

I want to import/update records from one file (dbase A) to another (dbase :, matching on names. The problem is that in the case of empty fields in the records that are updated (dbase A), the data from that field in dbase B are lost, thus overwrited with the empty field of A.

How can I maintain data in B if the field in A is empty?

Mireille

[IdealData]

Why not do this by a script and use the Set Field command only if the field in fileA has a value.

You will need a relationship to match with and the process will be slower the direct import - but you get the control you are looking for

[LiveOak]

If you use a lookup to update the data, you can specify "do not copy" if the field in the file copied from is empty.

-bd