Help

FILEMAKER PRO HELP 1250
• In the first, ColorsTable 1 and ShapesTable are related using the Style Number fields.
• In the second, ColorsTable 2 and ShapesTable are related using the Weight fields.
Because ColorsTable 1 and ColorsTable 2 share the same source table, a calculation defined in
ColorsSourceTable can be evaluated from the context of either the ColorsTable
1 table occurrence
or the ColorsTable
2 table occurrence.
To see how this works, consider the effects of context on two calculation fields in the table
ColorsSourceTable. Each calculation field uses the same formula to determine the sum of prices in
the table ShapesSourceTable; the only change is the evaluation context. ShapesSourceTable has
three records with these values:
A single record in the ColorsSourceTable has these values:
Because the relationships use different match fields, each relationship returns a different set of
related records.
Calculation result 1
The relationship between ColorsTable 1 and ShapesTable, which uses Style Number as the match
field, returns these two records:
A calculation field defined in the ColorsSourceTable with the formula Sum(ShapesTable::Price)
that is set to evaluate from the context of the table ColorsTable
1 returns the value $8.00.
Calculation result 2
The relationship between ColorsTable 2 and ShapesTable, which uses Weight as the match field,
returns these two records:
A second calculation field defined in the ColorsSourceTable with the same formula,
Sum(ShapesTable::Price), but set to evaluate from the context of the table ColorsTable 2
returns the value $15.00.
Shape Style Number Weight Price
circle 100 5 $2.00
square 100 2 $6.00
triangle 200 2 $9.00
Color Style Number Weight
red 100 2
Shape Style Number Weight Price
circle 100 5 $2.00
square 100 2 $6.00
Shape Style Number Weight Price
square 100 2 $6.00
triangle 200 2 $9.00