Importing to related tables

[fbugeja]

Hi All

 

I am still considering myself a newbie and my query may have been dealt with before.

 

I have a database which has a portal displaying records from a related table. I have exported all the records in this table as an Excel spreadsheet but, as a test on importing records into a clone of my database, I find that the Import Field Mapping dialog box where you match source fields from the Excel spreadsheet with the target fields in the Filemaker database, related tables are greyed out.

 

Does this mean that I cannot import to records from the Excel spreadsheet to the records in the related table in the portal?

 

Frank

[comment]

You can only import to one table at a time.

[fbugeja]

Hi

 

Repeated the trial again, but tried first importing records to the relatd table first. Did not work - related tables still greyed out. So it seems that while you cannot export records from a related table, you cannot import to them.

 

Frank

[comment]

You can import into any table - but only one table at a time. If you are doing the import manually, then that table is the table of the current layout (or a new table, if you so choose). If you are scripting the import, then you can select any table as the target table for the import.

[Sheju Sathyanesan]

Do you have any example script for this.. please help thank you

[comment]

@Sheju Sathyanesan Please don't be a pest.
http://fmforums.com/topic/99033-import/

[Lee Smith]

In other words, please don't multiple post your question. Whether you create a new topic or reply to someone else’s it is still multiple posting.

[Sheju Sathyanesan]

Sure... will make sure... Thank you