AnsweredAssumed Answered

How to Capture and Use Find, Constrain and Extend Criterion of a Found Set

Question asked by illumine on Jul 8, 2013
Latest reply on Jul 9, 2013 by philmodjunk

Title

How to Capture and Use Find, Constrain and Extend Criterion of a Found Set

Post

     Hi all,

     First, I consider myself a novice FileMaker user.  I've read through some -- not all of the FileMaker 10 Missing Manual, and understand the basics of the application, more or less.

     That said, I am attempting to improve a layout geared toward providing some rudimentaty analysis of specific data from thousands of records contained in one table.  I want the layout (and a report) to show the user what Find criterion was entered to arrive at the found set being displayed.  The resulting field (in browse mode) or label in a report should reflect the criterion as a sort of "bread crumb," "how-the-heck was this found set derived?" trail for the user.

     I found one earlier posting, http://forums.filemaker.com/posts/58d539de01, which seems to touch on the topic but doesn't seem too clear as to how one captures and then puts to use one or multiple Find criterion, constraint, or extension for the now displayed found set.

     It seems that such a task will require a "Find" button with an associated script to capture the user-defined search criteria, store that criteria in some fashion (global variable or global fields?), and then have them available for the use described above.

     Any ideas would be welcomed.

     Thanks,

     DC

Outcomes