Multiple Find

[jim shelton]

I know you can do a find for a range, but is there a way to do a multiple find without duplicating the request?

Lets say I want to find the job ticket records for jobs 801, 803, 811, 815, 833.

Is there a way to enter as a single find request or do some other time saving method?

thanks,

Jim

[comment]

No, but you can script the process of creating a request for each value.

Alternatively, you can enter the values as return-separated list into a global, and use a relationship to find matching records.

[Richard Wheaton]

Did you find a solution to the find for a range of field entries separated by a comma.

I know you can accomplish this by entering 123..or..124..or..,etc. but I am also looking for a better solution.

The database program I have been using for years allows the user to simply enter 123, 124, 125, etc. into any field returning the result of every record containing those values for that field.

Seedcode's fmSearchResults has a list search function that works this way but I would rather create my own simple solution.