Check Existing Question

[mentairia]

I need a way to build a search that will check Three critera instead of one. I then want it to list the results in a list below the boxes you filled in. I then need if the customer does not exist a way to copy the already entered critera into the proper fields in the add a customer page.

Ok I need it to do this

customername or customeraddress or customerphone

If you can just tell me how to do an or search I will figure out the rest.

Thanks

Tony D.

[SlimJim]

To do an OR search you put the first criterion in, then New Search put the second criterion in and so on. Personally I think the best way to do this is in Table mode as you get the criteria visibly sitting in rows in front of you. If you are going to do this a lot put a button for OR in the header or footer which simply does a new request.

[mentairia]

Is there no way to do an automated Query based on three critera where if any of them are true it will show the results. Adding searches is to much to ask of the infidels who work here. I want it to be automated based off three fields they entered with no other Idiot oh sorry user interaction Any Ideas would be great

Thanks

Tony D.

[SlimJim]

If it is three fields and no more than you could run it via a Custom Dialog box to pick up their criteria (in global temp fields) and then do the search via a script and show the results in a table. If you want them to be able to see their criteria on the layout then you can drop the Global temp fields onto the layout in the header (or footer) and make sure your table view is set up to include the Header and footer. You could build in deleting the contents of the globals at the beginning of each new search; on the other hand the users may appreciate the contents staying in there so that they can see what was done last.

[mentairia]

I Am not familiar with custom dialog boxes at all how do you use them. Any chance you could give me a sample of a search custom dialog box. I just want to understand it I want to disasemble it and see what makes it work. I really apriciate your time Slim

Thanks

Tony D.

[SlimJim]

Hi Tony

I am attaching a file with a search setup via a custom dialog box. The data is a few hundred records grabbed froma software database so that there is something substantial to search on. I was not sure what type of search you had in mind so I have set up a simple OR among three keywords in the description field. As you say, once you have seen it in action you'll be able to sort out your own version.

EDIT I just scrolled back through the post and I see that this is not exactly what you wanted - but I'm sure you can adapt it without too much problem.

SearchTest.zip

Edited August 8, 2005 by Guest