Search form.

[Larsrh]

Hi
Help needed too solve this problem.

Have a search form who call another form by using openform.

In the search form i have a text field and now the problem, i want to search as an example "the brown horse" and the result should be all records who have all tree words, but not necessary in the same field.

If a record have 3 fields
Field A : the white rabbit
Field B : horse
Field C : brownies
Result this record will be found by search

Another
Field A : The brown big horse
Field B : house
Field C : bla bla
Result this record also should be found.

Any suggestion to build the where statement.

 

[Larsrh]

If all the horses brown or otherwise are not in the same field you are going to have trouble searching them. Infact rabbits, dogs, horses.etc should be in one field, and houses and brownies should be in their own fields as well. Have a look here for ideas.

You are right, but it was only an example, it was to clarify what the search routine should do.
It was to show, that the search should look both in all fields but also if the search words are in the same field, or part of it.
Dont know if it is possible.
Had a thought to do a OR search with first to reduce records, and then do another OR search with the next word and so on.

 

[Larsrh]

Hi
Yes i did, but the search example cant search for different words in different fields.
I know my problem is complex and i dont know if it can be solved.