Hi LoisC,
thank you for your reply, but it seems that I did not make myself entirely clear. Your solution does work, IF the search terms is EXACTLY the combination of your separate search items. However, I would like to use multiple drop down menus (or one multiple select field) which would then be used to perform a boolean search on one specific field.
If I use the 'Multiple select filed mod (http://www.jpdeni.com/dbman/Mods/mult_select.txt) (with or without the boolean mod installed) and I do a search for different items selected in one select field, I will recieve a list of items containing either of the search terms.
Maybe I should discribe my problem more precisely.
I have three sets of data (called person 1, 2, and 3) each containing a filed specifying if they prefer red, blue, green, or a combination of them. Lets assume the following combination:
1. likes red and blue
2. likes red and green
3. likes red, blue and green
I'd like to be able to do a serach for all persons who like BOTH red AND green. The problem with the solutions you suggest is, that they would only look for the string "red green" if I was to select these two items and would therefore not return person 3.
I hope that this is more clear now.
Any suggestions would be appreciated.
Thank you in advance
adrian
thank you for your reply, but it seems that I did not make myself entirely clear. Your solution does work, IF the search terms is EXACTLY the combination of your separate search items. However, I would like to use multiple drop down menus (or one multiple select field) which would then be used to perform a boolean search on one specific field.
If I use the 'Multiple select filed mod (http://www.jpdeni.com/dbman/Mods/mult_select.txt) (with or without the boolean mod installed) and I do a search for different items selected in one select field, I will recieve a list of items containing either of the search terms.
Maybe I should discribe my problem more precisely.
I have three sets of data (called person 1, 2, and 3) each containing a filed specifying if they prefer red, blue, green, or a combination of them. Lets assume the following combination:
1. likes red and blue
2. likes red and green
3. likes red, blue and green
I'd like to be able to do a serach for all persons who like BOTH red AND green. The problem with the solutions you suggest is, that they would only look for the string "red green" if I was to select these two items and would therefore not return person 3.
I hope that this is more clear now.
Any suggestions would be appreciated.
Thank you in advance
adrian