Help on Scripting a find......

[mzimm]

I'm new to FM (and using Ver 6). I have a field called "status" and want to make a script to search for the records which contain "hold" and "testing" and "new". What is the best to go about this? Thanks

[-Queue-]

How many optional values are there for status? If there is only one or two more than you mentioned, then it would be most efficient to search and omit a single or multiple requests, i.e.

Enter Find Mode[]

Set Field ["status", "option1" ]

Omit Record

Duplicate Record/Request

Set Field ["status", "option2" ]

Perform Find[]

where optionX is any additional possible value.

Otherwise, multiple requests will work:

Enter Find Mode[]

Set Field [ "status", "hold" ]

New Record/Request

Set Field [ "status", "testing" ]

New Record/Request

Set Field [ "status", "new" ]

Perform Find[]