AnsweredAssumed Answered

Importing multiple tables into existing file with same tables

Question asked by tilbot on May 31, 2017
Latest reply on Jun 1, 2017 by TSPigeon

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

Outcomes