Jump to content

Importing into relational database


This topic is 8075 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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]

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

This topic is 8075 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.