Hello,

I am very new to using FileMaker 7.0 (3 days) and have a rookie question. I need to import data from an Excel spreadsheet to populate fields in only one of the three layouts I currently have. I am on the target layout when I go to import but when I select the file and see the available target fields they are from one of the other layouts. Do I need to create a script to perform this function?

Follow up...I have a single unique identifier field for all layouts and wish to associate my import data with that field. If I import that field with my new records but do not allow overwrite of that field will my new records be associated correctly with that field?

Kind regards,

J

Did you check your layout to make sure it is focused on the correct table occurrence? Layouts in FM7 are now associated to Table Occurrences (TO). For example if you have 3 tables in your file one called A, the second called B and the third called C and you wanted to import data into C you would need to be on a layout that is based on the table occurrence for C.

Ken,

I was focused on the incorrect layout. I am now importing successfully. Thank you for taking the time to respond.

Regards,

J