Script to go to a certain record in a layout based on the Name of a staff member
I am trying to setup a button that will take me to a certain record in a layout, the problem I am having is with setting the record number.
I have staff member names in a Field Called Performers:peformerID, I have tried setting the record number by calculated result where Peformers:PerformerID="aaron" for staff member Arron.
This doesn't seem to work as it always takes me to the first record in the layout.
I have also tried GethNthRecord (Performers:PerformerID; (Performers:performerID = "aaron")) but this also does not work
Does anyone know another calculation I might use?