Importing Find Results from another Filemaker Database
I have two databases. Main and Templates. In the Main database I have a layout that is assigned to a table in the Templates database. I want to filter the results in a table in the Templates database and then import just those records into a table in my Main database. My script IN MAIN looks something like this:
Go to Layout["TemplateDetails" (TemplateDetails)] // points to Templates::TemplateDetails
Perform Find [Restore] // The criteria for this Find is TemplateDetails::TemplateID [=$$TemplateID] // Verified $$TemplateID is correct and search results are correct
Import Records [No dialog, "Templates.fmp12"; Add Mac Roman] // This imports all the records in the TemplateDetails table instead of the filtered set.
Any help is greatly appreciated