By hand or with a script ?
And are the Bank and status fields part of the same table?
Either by hand or script.
The fields are in the same table.
Thanks for the replies.
Enter Find Mode [ ]
Set Field [ YourTable::Bank ; "TheBankName" ]
Set Field [ YourTable::Status ; "closed" ]
Omit Record [ ]
Perform Find [ ]
And if you define a global text field, the user can enter the bank name or select it from a value list before running the script raybaudi posted, but with one small change:
Enter Find Mode
Set Field [YourTable::Bank ; YourTable::GlobalField ]
// and so forth.
I'll give it a shot.
That works pretty good.
The only problem I have, is I can't edit the global field when in Find mode, it works fine in Browse mode.
It just won't let me click on the global field.
In field control both the browse and find checkboxes are checked.
You edit the global field in browse mode before you perform the script.
If your global field is formatted with a drop down list or Pop up menu, you can even set this up with a script trigger so that selecting the bank from the value list automatically performs the script and thus finds your records all in one step.
If there are additional criteria that the user needs to specify, then this approach can be modified to accomodate that need. Let us know if that's the case. Otherwise, the user should never even see the system in find mode as the script goes from browse, to find mode and back to browse all in the blink of an eye. (If it doesn't, you may have the pause check box selected where it shouldn't be in the enter find mode step.)