help needed combining files

[steveo123]

I have 2 copies of a FileMaker 4 file. They are identical except they contain different records. Is there an easy way to combine the two AND eliminate any duplicate records?

Thanks in advance!

[-Queue-]

Create a relationship from one file to the other, based on the field determining uniqueness (if more than one field is required, create a concatenated calculation field in both files and then a relationship between them). Then, in the file with the relationship, call it fileA, create a script

Find All

Go to Record/Request/Page [First]

Freeze Window

Loop

If [isEmpty(relationship::keyfield)]

Go to Record/Request/Page [Exit after last, Next]

Else

Omit

End If

Exit Loop If [not Status(CurrentFoundCount)]

This will leave you with a found set consisting of only records which do not exist in the other file, according to the field(s) determining uniqueness. From the other file, fileB, you can then import the found set.

Note that you may need to update the serial (if there is one) for the imported records, if any of them match an existing serial in fileB. If this is necessary, be sure to update any child records which use the serial to link to a parent in fileB.