No Duplicates - Unique value of 3 fields.

[ashill]

I thought I figured this one out…but…no

I have 3 fields – book number, revision, page number

I do not want duplicate combinations of these three fields so I thought I would set up a calculation field containing the data from these fields and use that to not allow a duplicate record to be created. But I can’t validate a calculation field. Is there another way to accomplish this?

Thanks in advance

[millmaine]

Rather than a calculation field, make it a text field that has an auto-entered calculated value of the 3 fields you want to use. Validation can then be set to ensure that this is unique.

[ashill]

Thanks for responding. I tried this first and it didn't work. I must have done something wrong because it works fine now. ;)