I'd like to know if I can create a script that will import a text or csv file into a table and then assign a specific foreign key to each of the newly imported records. Basically the Filemaker Table will have the following fields:
- RecordID (Automatically Generated)
The file to import will contain these fields:
The imported data will be appended to a table with existing data and then the ForeingKeyID will be added for each of the newly imported records.
Thanks for any help.