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) [arslist@ARSLIST.ORG] on behalf of Jase Brandon [jasebran...@gmail.com] Sent: Thursday, November 03, 2011 4:08 PM To: arslist@ARSLIST.ORG 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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
