Title

Finding all records matiching shown record.

Post

Using Filemaker Pro 11 Windows

Is there a way to make a script that will do a filter based on a displayed record "field"
I have a table that has many records of the same name from different dates.
I would like to be able to scroll to a name and then click a button to do a "trends" report on that name
Every time I make a sale, that sale is put into the database as a new record with all the info (Name, Date Etc...)

Example:

Lets say I wanted to see how a item was selling last year.
I would like to be able to scroll to that item, Click on a button and it to pop me to a "Trends" chart for that displayed item.

When Setting up Set Field, there are two Specify buttons that must be clicked. To get Set Field [Table::Field ; Expression], add set field to your script and click the first button (specify target field). Select Table::Field from the list of fields. Do not click the specify button next to the repetition box. Click OK to close this dialog box. Now click the lower specify button (calculated result) and create the expression to the right of the semicolon (;). Do not try to type in the semicolon.