AnsweredAssumed Answered

Excel Import: How to match on parent table's fields to import new records into related table

Question asked by NithyaLakshmanan on Sep 27, 2012
Latest reply on Sep 27, 2012 by philmodjunk

Title

Excel Import: How to match on parent table's fields to import new records into related table

Post

     I have 2 tables defined in Filemaker: Customers and Invoices.

     I have an Excel sheet with fields: Customer Name, Invoice #, Invoice Amount. 

     To import this Excel file, I want to validate first that Customer Name matches an existing record in parent Customer table. And only if there is a match, then create a new record in Invoices table with the Customer Name, Invoice #, Invoice Amount. How can I set this up?
     Still learning Filemaker. In the Excel Import setup window in Filemaker, I can select ONLY one table - both for matching and for record creation/update. In my scenario, the match is on the parent table's fields while the records are being created in related table. How can I configure this? Also, is there a way to log back into Excel which records did NOT find a match.

Outcomes