I have a fairly large number of fields (126) that I am importing. These fields belong in a variety of different tables within my application, therefore the only way to bring them all in at once is via a separate dedicated table.

I then need to be able to move that data to the different fields where they really belong. The only problem is that some imported records may be partial duplicates of existing ones in my database (requiring an update of that data), while others may be new records.

How can I begin to manually script this merge-purge procedure?

Update: I have an idea, though I haven't tested it yet...

The solution may be to skip the merge-perge effort and to run an import script multiple times, once for each table, beginning with the main one.

The key is to let the original import do the merge perge via FM's import settings, then reimport the other tables as updates. Comprende?

Not very eligant, but it may work.

(Then again, it may not!) B)