2 Replies Latest reply on Jun 1, 2017 7:29 AM by TSPigeon

    Importing multiple tables into existing file with same tables

    tilbot

      Morning all,

       

      I have a database that has 6 tables, 5 of which are related to the first.

       

      I have created a crude script that:

       

      Import records -  Specify import order - Database.fmp - table 1

      Import records - Specify import order - Database.fmp -table 2

      Import records - Specify import order - Database.fmp -table 3

      etc

       

      This is a button I've created but it's a 6 step manual process.

       

      Is there a better way to automated the process to link the import to Database.fmp and it automates the reoccurring?

      I can't use the "specify data source" in the script link because the file I import from changes names continually.

       

      Any help would be much appreciated.

       

      cheers

       

      DT