Jump to content

Find and constraint find buttons


Recommended Posts

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?

Link to post
Share on other sites

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.

Link to post
Share on other sites

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.

 

 

Link to post
Share on other sites
Posted (edited)

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 by stan111
Link to post
Share on other sites
Posted (edited)
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 by comment
Link to post
Share on other sites

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

 

1. find matching records

2. perform find

3. perform quick find

 

 

Link to post
Share on other sites

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) 

 

Link to post
Share on other sites

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.

 

  • Like 1
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.