Hello,

I have an application where I need to import data from a tab text file into two filemaker databases that have a parent/children relationship. Can anyone advise the best way to approach this.

The data looks like this.

parentrecordA1->Field A...Field K

childrecordA1->childfield1...childfield12

childrecordA2->childfield1...childfield12

childrecordA3->childfield1...childfield12

childrecordA4->childfield1...childfield12

parentrecordB1->Field A...Field K

childrecordB1->childfield1...childfield12

childrecordB2->childfield1...childfield12

childrecordB3->childfield1...childfield12

childrecordB4->childfield1...childfield12

Thanks for any help you can offer.

Paul S. Cuscione

[email protected]

You could check out this topic.

http://www.fmforums.com/ubb/ultimatebb.php?ubb=get_topic;f=13;t=000065

I posted a script that will import and split data into parent and child files. The example is similar to what you are trying to do, I think.

General Method:

Import the file into both databases. Then delete the child records in the master file and delete the masters in the child file. I don't know if you have a common key, otherwise you would have to generate one. Find and Replace commands could do that.

Greetings...