Importing Data to FMPro 12 from Excel
I recently began using FileMaker Pro 12 and am using the Time Billing Template. I would like to import time entries from Excel, but have not been successful thus far.
The database has one project table (Time Billings) and the data which is entered is stored in a related table named "Time Billing Data". I have configured one record in the Excel file with the fields which are entered in the Time Billing List. However, when I execute the File/Import Records/File command and select the Excel file with the one record, the Import Field Mapping dialog box shows only the Time Billings table as the target available for import. All of the related tables (including the Time Billing Data table) are greyed out in the Target drop down box, so I cannot select them. Also, the Target fields in the Time Billings table do not include the fields to which data is entered in the Time Billing Data table. Therefore, I cannot properly configure the import field mapping.
Please advise as to what I am overlooking.