calculation=1

[cauri]

I'm new to file maker 8. In the old (pre-7) versions I could create a simple field that had calculation=1 so that I could link tables to all the values in another table easily. Now that we have evaluation contexts for each calculation, what is the best way to achieve what I want i.e. a simple field that always has the value of 1?

[IdealData]

The relationships are now much more extended and you can use logical operators to determine the linkage characteristics.

The one you want to use is the "X" (cross-product) which will make a link on ANY FIELD.

[Inky Phil]

As Mark suggets you can use a cartesian join to replace a 'constant' relationship but this type of relationship will not allow you the 'allow creation of records' option when specifying your relationship.

To overcome this you can still generate a 'constant' field. Just specify the field to '1' from the context of the table in which it resides. That way it will always be a '1'

HTH

Phil

[comment]

this type of relationship will not allow you the 'allow creation of records'

When the child match field is a calculation field, you won't be able to create related children either - regardless of the "Allow creation..." settting.

[Inky Phil]

Oops! :