Jump to content

Doing multiple criteria in one field


ggillis
 Share

This topic is 5609 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi ggillis, welcome to FM Forums :wink2:

It would help to know whether this is a manual find or whether you want scripted solution. If you wish to search one field for two different 'OR' conditions, you would use New Record/Request to enter your second find criteria. Can you describe how this process will be used?

LaRetta

Link to comment
Share on other sites

  • Newbies

Thanks for the reply. My database is for a small neighborhood pool. I have a field with a drop down menu with "Active, Maintenance, Sold, and Bought Back" which is information about thier membership. I'm trying to do a find where two of these criteria is true. Example "Which members have a active and maintenance membership". How do I do a mulitple find in the one field? Thanks in advance for your help. It can be a find or script.

Link to comment
Share on other sites

It is called an AND search. Place your field as checkbox on layout. Create new script called Find Memberships:

Set Error Capture [ On ]

Enter Find Mode [ Pause ] ... do not specify any Find Requests

Perform Find [ ]

If [ not Get ( FoundCount ) ]

Show Custom Dialog [ OK ; "No records found." ]

Show All Records

End If

If you wanted an OR Search, you can capture (and count) the Search values using GetValue(), storing in global variables. Then loop, pulling each value separately and creating a new search request for each value.

LaRetta :wink2:

Link to comment
Share on other sites

  • 2 months later...
  • Newbies

Hi,

I have the same problem:

My clients can buy apparel and footwear, or only one of them.

My question is: how do i find clients who bought apparel (X) and footwear (S) --> they are stored in the same field

eg:

Smith X 110 pieces 2000 euro

Smith S 220 pieces 3000 euro

Jones X 100 pieces 1800 euro

Jack X 80 pieces 1600 euro

I'd like to find only Smith, since he bought both category's.

Thanks for helping me out.

Cheers,

Snake

Link to comment
Share on other sites

This topic is 5609 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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