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?

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.

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

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.

Oops! :