Jump to content
Sign in to follow this  
stevenjo57

Go to specific related record

Recommended Posts

I have a portal list within a parent database. I want to click on the specific line in the portal and have it take me to that record in the child database.

No matter what I do, the "go to related record" script takes me to the first related record in the child database.

I don't want the first one! I want the one I click on!

Thanks in advance.

Share this post


Link to post
Share on other sites

Place a transparent button over the portal row. Format the button to "Go to Related Record."

If it's done right in the portal row it works. If you are selecting the row and then clicking a button somewhere outside the portal, the default portal row number will immediately revert to 1, and that is the related record that you will go to.

Share this post


Link to post
Share on other sites

As Bob describes, I use a button outside the portal to do what you are describing. I like this approach because the function of the button is obvious due to its label. The function of the transparent button isn't always obvious to the user (after all, its transparent). The user first clicks on the portal row they are interested in, and then presses the button. The button executes a two-step script. The first step is a "Go to Related Record" in the child file. The second step is an external script in child file that is also "Go to Related Record," and opens the appropriate layout. This will take the user to the correct record in the portal row.

Good luck, Keith Silva

Share this post


Link to post
Share on other sites

Bob is talking about putting a button *inside* the portal row. He states that a button outside the protal won't work, it'll only ever go to the first row.

Share this post


Link to post
Share on other sites

You CAN do it with a button outside the portal row, BUT you must create another relationship based upon a global, make sure a portal row is selected, set the global to the index of the portal row, a "go to related record" for the global relationship. -bd

Share this post


Link to post
Share on other sites

Thanks LiveOak. I knew that a button outside the portal works, but I didn't know why. Your explanation of the global matches my setup and provides the reason why it works.

Thanks, Keith Silva

Share this post


Link to post
Share on other sites

Sorry, I didn't mean to mislead anyone into thinking that you can't put the button outside the portal. I just find that the button inside the portal avoids extra setup work and is often all a person needs.

Share this post


Link to post
Share on other sites

Thanks to all of you for this - definitely a big help! You just saved me hours of angst-ridden button-inside or button-outside turmoil.

I decided on a transparent button in the portal, but added a script step to put a mark in a field next to the portal, so that I know which row I clicked. It looks great!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    aztrix55 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.