Cant you just use "blueberry yoghurt" in your first find?
Or am I missing something obvious?
Also, you might want to make a second field for the "fat content"
That way you can more easily find products with certain "fat contents"
For instance if you want to find all non fat, or low fat products.
You could do that now as well, by making a search for those words, but it might be handy to separate this kind of information.
Also for your finds. When you do an AND find you first click "Find" then you type yoghurt.
Then you click "new request" and you enter blueberry.
Then you perform the find but then you'll find all the yoghurts and all the blueberries. (all records)
Thank you DaSaint
Your suggestion "just use 'blueberry yogurt' in the search field works! :)
I was making it too difficult for myself because of SQL heritage.
However, it would be nice if the training materials included an example of this kind of "AND" usage.
Again, thank you very much.
I'd also use the method DaSaint has recomended here, but to answer your specific question:
How do I use a Found Set as the basis for the next Find operation?
After performing a find, you can return to find mode, specify additional criteria and then use "Constrain Found Set" instead of Perform Find and FileMaker will omit any records from the current found set that do not match the additional criteria.
This can be accomplished in both manual finds and in scripts that perform finds.
Extend Found set can be used in like manner to add records to the current found set if they match the additional criteria--one of two ways to do an "OR" type query.