Auto-Enter calculation update when you create a new record. A non-store calculation updates automatically. I don't understand what you want to accomplish. Your post states that you have a self join which would mean that both field are in the same table, and if they have the same data, what is the point of two field. If you want to replace data on several records, it would be better to do a find replace.
the relative snip I want to create a report that counts records based on the company's status as 'client' , 'cancelled', 'free trial' and some other values in the Status field.
I wanted to create a script that would allow the User to select the Status which would modify the relationship to match records that matched the status and a Group code. E.g. Summarixpze the number of 'clients' by group code. Or use the same layout to us,,arise the number of 'canceled' by group code, etc.
I know there are other ways to do this but I was curious to know if this technique to create dynamic relationships could work.
Thanks for your help.
You can create dynamic relationships to view record based on the status but all you need is a relationship between the status and a global field that contains the status you want to view. The status field can be a drop down box to select the status of the record and the global field can be a drop down box to select the status you want to view. No scripts would be required.
You would create a report with summary field to total by status. Take a look at this link http://help.filemaker.com/app/answers/detail/a_id/790/~/creating-a-sub-summary-by-month
Instead of a sub-summary by month you would have a sub-summary by status
S Chamblee : Thank you very much. Your suggestion worked perfectly.
I created a popover on my sub summary layout that displays StatusConstant as a checkbox set.
The self relationship matches "Status" to "StatusConstant"
When I change the value in StatusContant, it immediately changes the sub summary report.
It's exactly what I wanted.