The following was posted in a previous post on “Preventing
Define a text field and set it as Auto-Enter -> Calculated value then
specify this calculation:
NameLast & NameFirst & EmailAddress
Uncheck "Do not replace existing value..."
Then on the Validation Tab, tick the Unique checkbox.
This will prevent you from having a record with the same Last Name,
First Name, and Email Address.
I am trying to emulate the calculation to include a project number......
I have a field with the following calculation:
Action # = Left (Discipline ; 3) &
"." & Item # which returns a result of Arc.01 if the Disipline is Architectural and
the Item # is 01
I want to prevent duplicate numbers in this field. But this field could be the same in another
project. I want no duplicate action # within a given project set of records. As you can see the project number is 0000 (my test project) and
the disciplines each start at 01. So another project could have these same Action #s but a different project number.