have the child records - what about the parents!

[Aussie John]

Hi I have been given an excel file with all of the children records. I was wondering if there was an easy way to separate out the Parent records when I import the table containing the parent info. cheers

Edited December 22, 2008 by Guest

[Ocean West]

as long as the children all have a key that is unique for each child of a parent record you can export them as summarized grouped by that field when you check the box only the first record of each set is exported, then import that set.

Alternatively you can create a looping script that compares the record next to it and then creates a corresponding parent record, should it not match the previous record (when the found set is sorted)

You could also use this technique to identify the first of a series then export or import that set of flagged records.

http://www.filemakermagazine.com/videos/unique-mod-div-three-powerful-techniques-for-record-ranges-free-video.html

[Aussie John]

Thanks - opening the excel first in FM then sorting and reexporting did the trick - interesting video too