Return to FileMaker.com
Need help with a Variable
I need to set a variable for a script that will create a sum of the values in a related table!
The related table contains a field called "z" containing the numbers to add
The related table is displayed on my layout as a portal and I know I could just "go to object" (portal) and create a loop to get the desired result.
As I am new to databases I would be interested to learn of a more streamlined approach to set the variable -
I would use the Sum function as a calc field in the parent table. Read up on it. It's very useful.
Retrieving data ...