FM - Best Way to Go to RR in External DB and Back Again
What would be the best way to go to a RR in an external db's layout and then return easily again given the following. In the first db, Sales Leads, you have a portal at the bottom that shows all Vacancies a customer might be interested in. This has a GTRR that brings you to the Vacancy db and layout. However, a Lead is not related in any way to a particular vacancy, so how do you get back?
I could set up a global in Vacancies and set it to the RecID of the Lead record that I am leaving and then have a Return button in Vacancies that takes me back using that global. Any better way? Maybe use the Hide Window and then Restore Window command, but not sure that would be reliable.
P.S. - I'm again having a problem. GTRR works great by itself as one step when I set the appropriate portal field as a button. However, if I try to put the GTRR in a script step (in this case so I can have an extra script step to capture the RecID in a global) it does NOT work. I've been through this before and people don't believe me so attached are the screen prints. Maybe a script works only in the local db, so cannot go to a related record in another db? But then why does the external tables layouts show and are not grayed out or something?
GTRR-inscript.JPG
GTRR-singlestep.JPG
I could set up a global in Vacancies and set it to the RecID of the Lead record that I am leaving and then have a Return button in Vacancies that takes me back using that global. Any better way? Maybe use the Hide Window and then Restore Window command, but not sure that would be reliable.
P.S. - I'm again having a problem. GTRR works great by itself as one step when I set the appropriate portal field as a button. However, if I try to put the GTRR in a script step (in this case so I can have an extra script step to capture the RecID in a global) it does NOT work. I've been through this before and people don't believe me so attached are the screen prints. Maybe a script works only in the local db, so cannot go to a related record in another db? But then why does the external tables layouts show and are not grayed out or something?
GTRR-inscript.JPG
GTRR-singlestep.JPG
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
GTRR should work just fine from within a portal but only as long as the focus stays in the portal. If you move away from the related portal record, there is no longer a "RR" to "GT".
ASKER