How to go from a portal row to a related record?

[soxfan]

Your thoughts on how to resolve this issue...

(I am new to FM development.)

I need to provide the ability to drill down within a portal.

For example: This application tracks redsox players, games and performance within each game. Each is related. Player -> Games -> Performance

Pedro is the player in the form view, there is a portal to the multiple Games that Pedro has participated in with the fields:

Game_id #: 102

Opposing Team: Blue Jays

Result: Win

Graphic Button (to go to related view for additional detail)

I have added a button to the line with game_id (102) and want to script the button to drill down to another form layout . The new form shows the Game_id(102) and has a portal that displays stats for each of the nine innings. (The game_id== game_id is the relationship. From Games to Performance)

When I attempt to navigate to the related record, I lose context. I have tried copying and pasting the game_id value and using the find operation, but have been unsuccessful. How can I grab the value from the (Game) portal row that is in context, store it, navigate to the new layout and find only the record related to the specific game (102), then display the performance records in a portal?

Thanks for the help...

[RalphL]

Have you tried using the script step "Go To Related Record"? Do not use the show only related records and it will take you the related record. If you use the show only related records it will take you to the first record of the related set.

You can use global fields to store game_id for latter use.

[Vaughan]

If you use GTRR(Show) it will find the related records in the related file, and take you to the selected record.

If show is unchecked it will take you to the selected record, but there will be no found set (all records selected).

[soxfan]

RalphL and Vaughan,

Your suggestions worked perfectly! Thanks for the help. (I used the show only related records to limit the set.)

Thanks again.

soxfan.