Go To Record in Unrelated Table
I am having a problem getting to a particular record in my database. I have a Record in a table marked Bills and I need to navigate to a record in a table occurrance marked Alerts based on a TO of Bills. Bills are referred to several committees and those referrals are displayed in the Bills Layout via portal. Now, I need to get to the alert for the correct bill for a particular referral. I can successfully navigate to the first referral using set variable and go to layout. But then I have to arrow over to the correct referral. Is there a way to write a script to get me all the way to the appropriate record (referral)?
Any thoughts would be appreicated.