It sounds like all you have to do is add a checkbox field. Unless I've misunderstood…again ;-)
After you do the first find (e.g. companies with a size greater than X located in Boston) then you can hand pick your favorites by clicking the checkbox for those companies. When done, modify the last find by selecting the checkbox in Find mode. That will further constrain your "found set" to only those companies.
Hope you make the deadline.
This is helpful, thank you. But since I'm still so new to FileMaker, half my trouble has been with implementing various methods. I can't seem to figure how to make checkboxes work properly (or at least the way I want them to). I was able to come up with a workaround by creating an "Omit" button that excludes the companies I do NOT want to include, but I can't seem to replicate that same functionality with an "Include" button or by way of a checkbox.
If I insert a checkbox set, what do I need to do with respect to setup or behaviors to make the checkmarks work/appear? Also, does this work in Table View, or only List and Form View?
You only need 3 things to enable a checkbox:
• The checkbox field itself on the layout. (I haven't tried it on the table view but it should work and is easy to verify.)
• A text field in your table that displays the data of the checkbox.
• A value list containing the word or list of words that act as labels on the layout. You can have one or more words depending on how many checkboxes you want in the set.
When you click a checkbox on, the corresponding value list item (label text) is set into the text field on the table.
As with any field, you can adjust the color and background of the checkbox.
So you may want to add a value list called, let's say "Include", that has one item in it, let's say "included". The word "included" will show up on the layout to the right of the checkbox and if checked will be placed in the associated text field of your table.
Hope this is clear enough.
I can't quite get it to work in Table mode or list mode for whatever reason, but I got it working in Form mode which is good enough as a proof of concept! I'll just have to keep working with the program to become more familiar with its ins and outs.