Indirect Referencing

[Binarybit]

When setting the criteria for a "Perform Find[]" how do you specifiy the contents of a field and not the field name? i.e.

Action = Find Records

Criteria = PaySlips::Employee: [=fEmployee]

fEmployee is a drop down field in my database and I want the search done based on the current value in that field. But all it does is search for "=fEmployee" and finds no records. Where as the field contains a value of "Brian". I just cant find any examples of indirect referencing.

Of course if I replace fEmployee with Brian it works but this is not practical as I may have 100+ employees and I'm not going to write a dedicated script for each person. Anyone know how to do this?

[comment]

Perform Find[] only works with static (stored) criteria. Try something like:

Set Variable [ $criteria ; fEmployee ]

Enter Find Mode []

Set Field [ PaySlips::Employee ; "=" & $criteria ]

Perform Find []