I have read that Filemaker pro 10 Advanced has the ability to import over multiple tables.

So far I have only seen posts about other Fmp files... is it possible to do this with an excel spreadsheet?

I have a few users I would like to simplify this process with a scripted button.

But the issue always was that the records they wanted to import were in a different table.. but the identifier for importing "matching" records was in the main table.

So in the past I have always had to take control and import the records for them with the necessary keys etc... not easy for an average end-user.

Any Suggestions?

I am not aware of any changes to the import process as such. You can import from Excel files but you will still have to do separate imports to each table.

One suggestion for you may be to import into a temporary table and script the process to write to your other tables using either loops and/or additional imports within the file.

is it easy to script the import process like that?

I dont think it would be too complex. Basically after you get records into the main table, you can take the ones that were updated there and then go to your other tables and add / update the records in those child tables. Set the foreign key there with Main table ID ( I am assuming parent table ) for the new records.