How to auto populate master/parent table when importing data into related/child table

[gjowilson]

Hi,

 

I have a parent table containing ID and some other basic fields. There are two child tables feeding into this - each with their own set of fields. 

 

Parent: __pkParentID

Child: __pkChildID, _flParentID,...(other fields)

 

I have many records that I wish to import from an excel doc into a child table. I can do this, but can't work out how to auto populate the parent table.

 

Any hints/tips etc?

 

Thanks in advance.

[LaRetta]

Try this:  http://fmforums.com/forum/files/file/60-migration/