Importing from Excel into Layouts related fields

[Medusa]

I'm struggling with importing data where there are related fields to be linked.

I have an excel file which I want to import. Each row of the file contains information which relates to an event i.e. Date, place, etc and also information on a related person i.e first name, last name etc.

The tables Event & Person are related tables.

It seems I can only import into 1 table at a time so how do I go about populating both tables from my Excel file and linking them so the fields appear correctly in my layout.

[IdealData]

Run it as a 2 stage process.

First get your excel data into a new tables, say Events_Import and Persons_Import.

Now you have the data inside FM then you can massage it as you like, before doing the second import when you import the Events_Import and Persons_Import into the real tables.

[Medusa]

Thanks for the reply. I suppose I am only importing into two tables anyway, so what I'm doing is just as easy. I was just trying to think of a way to automate it more.