- Enter find mode
- Enter criteria directly in the field
- Perform the find
This can also be scripted to use data entered or selected via value list in a global field.
Enter Find Mode
Set Field [YourTable::YourFIeld ; YourTable::GlobalField]
Set Error capture [on]
YourTable::GlobalField must be set up with global storage or this script will not work.
I understand that when you change a field to "global" you loose all the data in that field? Also, how do you get the second part of the
Set Field [YourTable::YourFIeld ; YourTable::GlobalField] in the scripting formula?
I feel like I'm so close but yet still so far. My database is complete except for this part.
You don't change the field, you add a new one with the global storage option and only used for the purpose of your user entering the search criteria.
To add the second parameter of Set Field (the expression to the right of the ;) Click the second, lower specify button to bring up the specify calculation dialog.