1 Reply Latest reply on Sep 7, 2009 2:32 AM by comment_1

    Import CSV into more than one table



      Import CSV into more than one table


      I am testing Filemaker Pro 10. I have 2 tables, Competitors (compeditorID,name, address, etc.) and Scores (compeditorID,event1,event2, etc.). I want to import a CSV file of scores (name, event1, event2, etc.) by matching the name field and then somehow populating the scores table correctly.
      I am trying Import Records -> File, but it will only let me import the CSV fields into one table.
      Can this be done with Filemaker?
      Do I have the table structure setup correctly?
      Do I need an import table or something?
      Can you suggest the best practice to achieve this?
      Any recommendations would be appreciated.