Jump to content

calculation=1


This topic is 6460 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6460 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.