I am in a layout list in browse mode which shows 12 records from a find. I would like to place cursor over one of the 12 records making this the active record and then go to a new layout which would show only this record. I can get to the new layout and see this record but the record is one of 12 still in the found set. I would like to have this current record be the only found one. Can you somehow find on the active record?

There are a couple of ways to do this but I think the easiest way would be to create a self join relationship on the unique RecordID key field.

Then you can use a simple Go To Related Record with the option of showing only related records.

The other way to do it is set a global field with the RecordID and then perform a find.

There is another option here ...

User clicks the row. Script fires:

Show All Records

Omit Record

Show Omitted Only

If [ Get ( FoundCount) > 1 ]

Perform Script [ ... this script again ... ]

End If

The purpose of the If[] is to protect from the possibility that, if multi-user, someone else creates a new record a nanosecond after you've omitted (which would appear in the omitted set when then shown). If you create a new window first (based upon same layout so would show same current found set) then perform the script in the new window to produce the NEW found set of 1, you won't even lose your prior found set in the previous window.

Your selected OMIT record will remain the active record throughout this process.

UPDATE: I am all for using GTRR. But cluttering the graph with ANOTHER table occurrence just to isolate one record seems unnecessary here.

Edited January 5, 200620 yr by Guest
Added update

This worked to perfection! Thanks for the help!