2 Replies Latest reply on May 10, 2017 11:36 AM by BruceRobertson

    Open/Import Script

    tas_1

      Afternoon all,

       

      I'm wanting to open another filemaker file and then import specific data from the starting file; i.e.,

       

      From file "Case Event"

      Open "Case Notes"

      "Import" specific fields

      remain in Case Notes for data entry

      then return to Case Event

       

      I think I can return to "Case Event" with a separate script/button...

       

      Thank you in advance for your time and assistance.

        • 1. Re: Open/Import Script
          mikebeargie

          If both files are referenced, then you should be able to just have a script in File A that runs a script in File B. The File B script would import records from a referenced File A, then close itself.

           

          File A Script:

          Perform Script [ From File B ; Import Records From File A ]

           

          File B Script (Import Records From File A)

          Go To Layout [ File A Records ]

          Perform Find [ Records to Import ]

          Go To Layout [ File B Destination ]

          Import Records [ map File A table to File B destination ]

          Close File [ File B ]

          • 2. Re: Open/Import Script
            BruceRobertson

            Note that you can have multiple tables within one file. There is no need for these to be separate files.

            Understood that they are separate tables; and perhaps you truly do need to perform an import.