Comparing records between two files

[Tom2001]

Hi, I'm a newbie. I would like to compare records between two files (FileA.fp7 and FileB.fp7) and update only FileB. I am writing a script that loops through all the records of FileA and asks if that person (LastName, FirstName, etc.) is in FileB. If so, update FileB; if not, add the person to FileB.

I am stuck on a script statement in FileA something like:

Perform Find [in FileB] LastName=... AND FirstName=...

How can I get a script in FileA to find a record in FileB? The two files are not normally related (and not normally on the same computer) but occasionally this update is necessary and the files are copied to the same computer.

Thanks,

Tom

[comment]

See if this helps:

http://www.filemaker.com/help/12-Import%20export9.html

[Tom2001]

This looks promising.

Thanks!