Find and constraint find buttons

[stan111]

Gents, I am a bit confused with Find and Search functions in FM.

I need two buttons:

1 - find all Phones from DB

2 - find among those phones an Apple items

 

What functions I have to apply in this case?

[Ocean West]

It is a little unclear what it is you're asking where are the "phones" located in one field, multiple fields, in a dedicated table?

could you explain further your use case.

[stan111]

"phones" belong to Category field

"Apple" belongs to Producer field 

 

[Ocean West]

so are you looking for Phone numbers? or record that have a category "Phones" ?

If its the latter you its a simple AND type find enter "Phones" in the category field and enter "Apple" in the producer field you should have a found set of only that criteria.

 

 

[stan111]

I want to find all Phones (from the Category field) and further narrow down to Apple phones.

 

And I need two separate buttons for this purpose.

Edited July 6, 2020 by stan111

[comment]

25 minutes ago, stan111 said:

I want to find all Phones (from the Category field) and further narrow down to Apple phones.

To find all records that have "Phone" in the Category field, do:

Enter Find Mode []
Set Field [ YourTable::Category; "Phone" ]
Perform Find []

To find records in the current found set that have "Apple" in the Producer field, do: 

Enter Find Mode []
Set Field [ YourTable::Producer; "Apple" ]
Constrain Found Set []

If you want, you can reduce each of these scripts to a single step by storing the find request within the Perform Find / Constrain Found Set step.

As already noted above, you can find all records that have "Phone" in the Category field AND "Apple" in the Producer field by doing a single find with both criteria.

 

Edited July 6, 2020 by comment

[stan111]

thanks! In the meantime, what's the difference between:

 

1. find matching records

2. perform find

3. perform quick find

 

 

[Ocean West]

1. Find Matching Records

Looks for all values in that selected field for matching record with the contents of that field

2. Perform Find

Executes the perform find after entering find mode or by criterion entered in the dialog 

3. Perform Quick Find

Searches all fields on the layout local or related for a value entered ( same as using the search box in the upper right corner of the window) 

 

[comment]

I could not possibly answer such a wide question in a forum post. I suggest you read the help to understand what each of these does and if you encounter a specific question or problem, ask here. 

I will give you one hint, though: Perform Find[] is the generic way to find records; both Find Matching Records[] and Perform Quick Find[] are shortcuts for specific situations.

 

[stan111]

thanks!