AnsweredAssumed Answered

Importing records from an unrelated external Filemaker database

Question asked by alfredonm on Sep 17, 2013
Latest reply on Sep 17, 2013 by philmodjunk

Title

Importing records from an unrelated external Filemaker database

Post

     I'd like to import records from a Filemaker Pro 10 database that it is set as an External Data Source but it is not related to the actual database where the data will be imported. Basically the script looks like this:

     Set Error Capture [On]

     Open File [Open hidden; "Study Request"]

     Go to Record

     Set Variable[$$SerialNumber;Value:Study Request::SerialNumber]

     ........................

     but when I try to specify the value of the variable in the "Set Variable" Options windows, the database from which I want to import records does not come up because it is not related, and if I set it manually I get the error "the specific table cannot be found"

     I don't want to open the external source when I start the database because it is shared...

     Does anyone know a workaround this?

      

     Thanks!

Outcomes