Newbie scriptor here using "FileMaker Pro 5 Bible" to learn scripting.

I have a database which has two portals, each related to a separate database. When I use "Go to Portal Row" in my script, it always go to a row in one portal. I want a script to go to a row in my second portal.

The "Bible" states that this command "enables you to move to a particular row in the active portal. If a portal isn't active, the step is applied to the first portal encountered in the layout's stacking order (that is, the front-most, highest one.)"

I can find no referrence to how one makes a portal "active" or "inactive" nor can I find any referrence to the layout "stacking order" "frontmost" or "highest"

Right now I go into layout mode and delete the first portal when I want to run the script that referrences the second portal. This can't be the way it is meant to be done.

Help please.

The stacking order they are referring to is the order that objects appear on the layout (like in a draw program)... normally it only matters when things overlap.

If you always want a particular portal on top simply select it and go to Arrange > Bring to front. This was discussed a few days ago in another thread... I'm not sure what the workaround is... maybe have two different identical layouts which the script would first switch to.

Take a look at this thread Go to Portal

The answer is to use two script steps to navigate to the correct field/portal AND the correct portal row:

Go to Field(RelationshipForDesiredPortal::DesiredField)

Go to Portal Row

-bd