Non constraining search

[Esmo2000]

I have several fields which I want to be able to search with, but i don't want it so that the search must satisfy ALL of the criteria. In otherwords, i want it to search for field 1 and/or field 2 and/or field 3.

So for example, if field 1 met the criteria, but field 2 did not meet its criteria, it would still bring up that record.

How would I go about doing this? Thanks a lot!

Jim

[dbruggmann]

Two ways: Use a request for every field to be searched (use the "Add a new Request" command in Find mode). Or define a new calculation field, which concatenates the contents of the fields, you want to search in, and insert your criteria in this field.

[Esmo2000]

How is that possible when I want to do it with a script however? E.g. they have gone onto a screen in find mode with all the fields that will have the criteria, but the status menu will be closed to them. (I want to constrain the user from doing stuff that might confuse them).

On that note, the amount of fields it would take to do all those calculations would be really bothersome. Is there no other way to do it?

Thanks so much, I appreciate all your help!

Jim

[dbruggmann]

Sorry, if I didn't make my self clear!

Regarding the scripting: You can place a button on the Find Layout named "Add Request" and attach a script which uses the "New Record/Request" script step (in Browse Mode this creates a new record, in Find mode a new request).

And yes, the version with the calculation field won't work for your needs, because you could only enter one search criteria