Jase, You might also want to check if after you created the field, if you have input values into that field that are not unique.. In that case you will not be able to create a unique index as the DB will throw a unique index violation error.
I cannot confirm as of now if you cannot create a unique index on an overlaid form, but I think I had done that in the past with no problems.. Cheers Joe From: Melissa reed Sent: Thursday, November 03, 2011 4:57 PM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Re: Adding a Unique Index to COM:Company ** You can create the unique index on the base form, when you take it out of best practice mode. From: "Cecil, Ken" <[email protected]> To: [email protected] Date: 11/03/2011 03:55 PM Subject: Re: Adding a Unique Index to COM:Company Sent by: "Action Request System discussion list(ARSList)" <[email protected]> -------------------------------------------------------------------------------- ** Just to confirm I checked and creating more than one unique index on COM:Company in 7.5.x was no problem. So yeah, must be an overlay limitation as Guillaume reported. Ken. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Guillaume Rheault Sent: Thursday, November 03, 2011 4:15 PM To: [email protected] Subject: Re: Adding a Unique Index to COM:Company ** Hi Jase, I am 99.9999% sure you cannot create a unique index on an overlaid form, that is a known limitation... You can only create unique indexes on custom forms. So the only thing you can do is create two filters that fire on submit and modify: 1st one checks whether the value is already present in another record in teh same form 2nd props the error message cheers Guillaume -------------------------------------------------------------------------------- From: Action Request System discussion list(ARSList) [[email protected]] on behalf of Jase Brandon [[email protected]] Sent: Thursday, November 03, 2011 4:08 PM To: [email protected] Subject: Adding a Unique Index to COM:Company ** Hello All, I need to add a unique index to the COM:Company form to ensure that a custom field maintains a distinct value on submit. But.... there is already a unique index on the Request ID field on COM:Company, and dev studio won't give me the option to add another unique index on the field I want. I thought "oh yeah - only one unique index per form", then for jokes n' grins - I checked HPD:HelpDesk - which has two unique indexes, both character indexes. So that proves more than one unique index is available per form. What am I doing wrong? Any suggestions from the gang? :-) FYI... COM:Company is already overlaid as well as the view I'm working with. Thanks in Advance, Jase Brandon 7.6.04 SP1 Windows 2008 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
