Perform find based on checkbox set
I have what Im sure is a simple problem. I have a table called CPU Database. One field in the table is called "Type". This field may contain only members of a value list called "Type List". These are various types of devices....Mac Desktop, PC Laptop, Printer, etc.
Now...Id like to have a filtering system for the records. My idea is to have another field in the footer called "Filter" which displays as a Checkbox Set and displays values from the same "Type List" value list. The user could select here which types they want to show in the table and click a button above it to activate the filter.
I need a script now to attach to the "Activate Filter" button that will get the values of the checked boxes in the Filter field, and perform a find for records who contain any of those values in the Type field. Ive done a bunch of googling, but I cant seem to figure out how to do it. Any help would be greatly appreciated!