Importing records from an unrelated external Filemaker database
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?