Here's one method:
- create a summary field type List of: for the field that identifies the desired record.
- after you've found the user's records, use Go to Record [ by calculation ], using this formula:
Let ( [
theList = YourTable::theNewSummaryField ;
theRecord = Char(13) & $yourVariable & Char(13) ;
thePosition = Position ( Char(13) & theList & Char(13) ; theRecord ; 1 ; 1 )
ValueCount ( Left ( theList ; thePosition ) )
If you like, replace Char(13) with the pilcrow (CR symbol) from the operator list.
You might also use Go To Related Records with a self join that uses a global field to jump to a specific record within your found set.