Newbies cauri Posted September 12, 2006 Newbies Share Posted September 12, 2006 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 More sharing options...
IdealData Posted September 12, 2006 Share Posted September 12, 2006 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 More sharing options...
Inky Phil Posted September 12, 2006 Share Posted September 12, 2006 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 More sharing options...
comment Posted September 12, 2006 Share Posted September 12, 2006 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. Link to comment Share on other sites More sharing options...
Inky Phil Posted September 12, 2006 Share Posted September 12, 2006 Oops! : Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6570 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 accountSign in
Already have an account? Sign in here.
Sign In Now