09-05-2012 10:44 PM
I'm trying to add a 3rd e-mail field in my ACT database other than the two default e-mail fields, E-mail and Personal E-mail.
I create the field in the define fields window, but when I select e-mail as the field data type, the 'customize field behavior' options "gray out" and are not accessible.
When I click finish I receive the following error message,
"TBL_PICKLISTITEM_TRI1: This field exists in another view. Address, e-mail and Phone fields must be unique. To continue, give this field a new name.
The transaction ended in the trigger. The batch has been aborted."
I do not have this field anywhere else in the database. I have renamed the field and get the same error message. Can you only have two e-mail fields in the ACT database?
09-06-2012 09:10 AM
there is likely an Email field in groups or companies with the Email field name you are trying to use. Have you tried a different name to see if that works?
09-06-2012 09:17 AM
1.) Have tried changing the name of the e-mail field and get same error message.
2.) E-mail field is not being used in Company or Groups or anywhere else for that matter.
09-07-2012 06:40 AM
09-07-2012 08:11 AM
09-07-2012 01:22 PM
Did the database maintenance, which I do routinely with back-up. This didn't change anything.
I was able to add the e-mail field in the ACT! Demo database.
Something 'hinky' with my database.
09-07-2012 02:05 PM
Try running the database repairs in ACTdiag.