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

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


      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.