Doing multiple criteria in one field

[ggillis]

I want to perform a search for multiple data in one field.

How do I do that? Any help?

[LaRetta]

Hi ggillis, welcome to FM Forums

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

[ggillis]

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.

[LaRetta]

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:

[Snake Plisskin]

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