Hi,
I have an existing object called account in project that is based on the baseentity object and includes a lookup field to the account object and a lookup field to project. (and some more simple fields) I want to add an unique index to avoid having duplicate schools in the same project. I created an index and added the account field and the project field, and checked the unique checkbox.
WHen I publish, I get an erroe message: Failed to update structure for following schemas: "UsrAccountInProject","UsrAccountInProject","UsrAccountInProject"... (6 times)
Am I doing something wrong?
Thanks,
Chani
Like
Do you happen to have data in this table already that violates this uniqueness?
Do you happen to have data in this table already that violates this uniqueness?
Ryan Farley,
I did make sure that I don't before adding the index but I forgot to check for records not filled in. Now removed those records and publish was successful.
Thank you Ryan for the quick respond