How to go to a particular record but keep found set

[aharown07]

I think I missed this somewhere, but how do you go to a table, find a particular record in it, but preserve the current found set?

Here's a particular scenario:

I use GTRR to go from Table B to Table A. The relationship takes me to just one record in A (I print a report from that).

Then I want to stay at Table A, but expand the found set (but not quite to "all" records in the table).

If I do a GTRR, via self join in Table A, I can get to the subset I want easily enough, but I am no longer "looking at" the same record.

How can I get back to it or stay at it without using "show all" (... for various reasons I don't really want to show ALL).

I guess I could do a find... but is there a way to get GTRR to do this?

[Robert Kidd]

Add a global field in table A and another self joing relationship from A to A matching the Global field to a serial number.

Script your GTRR as:-

Set field Global as serial number

GTRR your original self join ( show only related records )

GTRR the new self join ( do not check show only related records )

[aharown07]

thanks a million. I would have never thought of that! (well, never is a long time, but I might never have)