3 Replies Latest reply on Nov 18, 2016 3:36 AM by ja.marting

    Import data from csv or text file with a twist...

    kalfred

      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:

       

      1. RecordID (Automatically Generated)
      2. ForeignKeyID
      3. Data001
      4. Data002
      5. Data003

      The file to import will contain these fields:

       

      1. Data001
      2. Data002
      3. Data003

       

      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.