Runing a Script in a related database

[jimkent]

Is there any round about way to run a script in another related database in order to bring up a related database report?

I am using Portals in my main database (main db - Parents Name, related database - there kids and grade info). I cannot create a report in the main database sorting on the portal information (i.e. Childrens first names within a parents last name).

When I attempt to create the report, it only sorts by the first child in the portal. If each child is in a different grade, it wont split it up. therefor I have to create the report from the children.fp5 database which is a related db and call it from the main DB. WOW! sorry to be wordy.

[CobaltSky]

Hello Jim,

There is a quite straightforward way to trigger a script in the related database. Simply create a script in the main database which has the step:

Perform Script [sub-scripts, External: "YourFile.fp5"]

You'll find the Perform Script at the very top of the list of script commands in the scriptmaker window, and once placed into the script window, the menu of options at the bottom includes the 'External' option at the to When you select external, you will be prompted to specify which file and which script ion that file.

If you are wanting to generate parent reports one at a time, you might wish to precede the external script command with the command:

Go To Related Records [YourFile, Show]

to find the records related to a given parent record prior to launching the sub script in the related database (which would presumably sort, switch layouts, print and then return the user to the parent database).

Of course, the final two steps in the sub script in your related database can also be a Perform Script [ ] step, to call a script in the main database which brings it to the front, followed by a Toggle Window [Minimize] step to dismiss the related database window.