Constrain found set with calculation

[no23rman]

How to do this?

2 fields (name, data)

I'd like to show all "data" with calculated result "name"

so

1. show all

2. constrain found set with calculation to specific "name"

I wanna do it through ShowAll->ConstrainFoundSet, and not through EnterFindMode->SetField->PerformFind

is there a way to use ConstrainFoundSet with calculation?

[IdealData]

As you will be scripting this then why not pass your variables into $vars. Use the SetFIeld script step to enter data into the fields during your find request.

[comment]

I wanna do it through ShowAll->ConstrainFoundSet, and not through EnterFindMode->SetField->PerformFind

You CAN do it through:

Show All Records

Enter Find Mode []

Set Field []

Constrain Found Set []

However Show All Records, then Constrain Found Set[] is redundant. Perform Find[] achieves the same thing more efficiently.

[no23rman]

thanks for the response everyone

the goal here is to have as little scripting as I can to perform constrain data within a found set.

is there a way to do "Find" within a "Found Set"?

as I understand Perform Find[] is searching throughout the entire database.

Edited April 30, 2010 by Guest

[comment]

is there a way to do "Find" within a "Found Set"?

Yes, with the Constrain Found Set[] step.

As mentioned earlier, if your criteria is dynamic (i.e. calculated at script runtime), you need to use the following structure:

Set Variable [ $name ; ]

Enter Find Mode []

Set Field [ YourTable::Name ; $name ]

Constrain Found Set []

[Fitch]

Constrain is available as a menu command, no scripting required. That's how you find within a found set. Seems like your question was already answered, but I might not be understanding what you really want.

Keep in mind that unless "name" is a global field, it won't have a value in Find Mode. Therefore you'll want to use Set Variable to store it, as suggested above.

In FM11 you can use variables directly in Find/Extend/Constrain script steps, but as your profile indicates FM9, you'll need to use the Find>Set Field>Constrain script construct as the post above yours explains.

[Søren Dyhr]

thanks for the response everyone

the goal here is to have as little scripting as I can to perform constrain data within a found set.

is there a way to do "Find" within a "Found Set"?

as I understand Perform Find[] is searching throughout the entire database.

Thinking slightly out of the box here, would GTRR(FS) perhaps fit the bill. Provided each of the fields are selfjoined to themselves ... something not very far from:

http://sixfriedrice.com/wp/deleting-duplicate-records-in-filemaker/

But here is a single line of script, perhaps attached to a button only, all it really takes.

--sd