Jump to content

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

Recommended Posts

One way to do this would be to:

1. Create a stored calculating field (result type Text) called "CompositeKey" with a formula which concatenates your three fields, viz: Field1 & Field2 & Field3

2. Create a value list called "Unique Keys" which uses values from the "CompositeKey" field.

3. Validate each of the three data entry fields (Field1, Field2 and Field3) with the formula:

not PatternCount(ValueListItems("YourDBname.fp5", "Unique Keys"), CompositeKey)

The result of this will be that although non-unique values will be able to be entered into the individual fields, values which combine with other values to generate a non-unique value in the 'CompositeKey' field will be rejected. You might want to consider making the validation strict and adding an appropriately informative custom message... smile.gif
Link to post
Share on other sites

This topic is 6566 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.