What is the easiest way to do this find?

[picnichouse]

Hi,

I have a database full of food products that we sell, prices and descriptions. We often need to create personalized menus for the restaurants to which we sell food.

Right now I have a menu layout that works fine, the main problem is that it's kind of tedious to go through and omit each of the hundreds of products that aren't on the menu until I have only the ten or so that I want on the menu.

I'd like to set up an easy kind of "find" where I'm presented with a checkbox for each product name, and then the database finds all the checked products.

What's the easiest way to do this?

Thanks!

Andrew

[Fitch]

Create the checkbox as a number field, and assign it a value list of "1". Shrink the field so you don't see the 1, you just see the checkbox. Create a caculated field that equals "1". Create a self-relationship, calc::checkbox. Now you just need a button, assign it Go to related record( relationship ). Much quicker than a Find.

You'll also probably want to make a script that clears all the checkboxes before you start.