In the Find mode place "Tom" in the appropriate field. Ctrl-N (Cmd-N on Mac) for second request type "Jerry", repeat for each request. If you want all "tom" but only "Jerry" in "TX" the second request would have "Jerry" in the name Field and "TX" in the state field. Then click on PERFORM FIND.
Yep, I know it can be done that way.
But I want to know if you can do a this find with one request and not have to create two requests.
Like in Ebay if you want to search for Nikon D800 & Canon 5D you put this in the search field : (nikon d800, canon 5d)
Is there a way to do that in the search area on one request?
When you put all criteria in the same request you are specifying an "And" find where you are requesting all records where the field contains Tom AND Jerry AND Pumpkin.
When you segregate the criteria into separate requests, you are specifying an "OR" find where you are requesting all records where the field contains Tom OR Jerry OR Pumpkin.
This does not mean you have to force uses to create separate requests to perform a find. Like all database systems, it's often necessary to set up your own layout where the user selects/enters criteria and then a script makes life easier for the user by constructing the needed query for them. A script can loop through a list of specified criteria such as this, construct the needed requests and then performs the find for the user.