Constrain Found Set question

[Rich S]

Howdy, all:

I have a solution but just can't get the Constrain Found Set to function the way I want it to. Here's the scenario:

Two related tables: Main and Costs

In the first part of the script, it jumps from Main to Costs to perform a find for all the records within a user-defined date range (for the field, Date.) I encoded a simple Enter Find Mode--Set Field--Perform Find set-up and it finds 10 out of 15 records within the entered date range. Cool.

A few lines later in the script, the user selects a cost category from the Main::Cost_Cost_Category field. The script then jumps to the Costs table where Constrain Found Set will look through the 10 found records (from above) in the Costs table to constrain the records that have the same cost category in Costs::Cost_Category field as in Main::Cost_Cost_Category...and that's where I get hung up.

See the attachment: What do I need to enter in the Criteria window Operator-wise to make that happen...or am I missing something here?

TIA for your help!

Rich

[comment]

What do I need to enter in the Criteria window

Nothing. Use the same method of Enter Find Mode--Set Field--Constrain Found Set. Only static criteria can be entered into a stored find request.

[Rich S]

Ah. Thanks. Well, that kills off my next question about using a variable in a Find, then. :S