I'm familiar with MS Access and the ability to perform a query to grab a subset of data, and use that subset to add new records and search within said subset. What is the equivlent process in FMP 12?
Thanks for any help.
Try the Constrain command. This is a menu item (for manual queries) and a script step (for automated queries). It works off any found set (whether you add records or not to the set) of records.
-- sent from my iPhone4 --
Here are the help topics;
Retrieving data ...