Selecting multiple records with checkboxes
I have a list of vendors (name, address etc.), each vendor has a set of products he sells (value list as checkboxes). I have a find screen that duplicates the checkboxes for the products. When I choose product "a" the correct vendors are shown, however if I choose product "a" AND product "b" only the vendors that have them both checked show in the find results. What I would like to be able to do is to have the vendors that have both show AND any vendors that have just "a" and vendors that have just "b" show as well. In other words show ALL the vendors who have ANY of the checkboxes selected in the search.
I'm fairly sure this is possible, any help ia greatly appreciated.