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 _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ ******************************************************************* This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept for the presence of computer viruses. www.Hubbell.com - Hubbell Incorporated** _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
