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.