Importing Excel to layout with mutliple tables

[Medusa]

Hi, I am pretty new to Filemaker so please be patient with me:)

My problem - I have a layout which shows multiple records in form view, where each record consists of multiple related tables (Events & Persons).

I can obviously type an entry directly into the layout and it populates both tables. So, how do I do this as an import since the import only allows me to import to one table at a time.

I am currenlty able to do this but it takes a lot of manipulation since I have to create the data first in the "persons" table in order to get their "key" and then add that key to a new import file to populate the "event" table with.

What techniques can be used to automate this? I have heard mention of creating an import table and somehow looping through this table to populate my layout. Is this right? and if so, where can I find a more detailed explanation of doing this.

I hope you can make some sense of this rambling.

[bruceR]

"So, how do I do this as an import since the import only allows me to import to one table at a time."

That is correct. So two imports.

But it would be probably be a good idea to provide more information. Seems likely, for instance, that you could end up with multiple records for the same person; or multiple copies of the events.