Re: Adding a Unique Index to COM:Company

2011-11-04 Thread Guillaume Rheault
: Thursday, November 03, 2011 4:57 PM To: arslist@ARSLIST.ORG 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 kce...@hubbell.com To:arslist@ARSLIST.ORG Date

Re: Adding a Unique Index to COM:Company

2011-11-04 Thread Joe Martin D'Souza
: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Adding a Unique Index to COM:Company ** I would not recommend that... next time he upgrades, he may run into issues, since that is an invalid customization. Guillaume

Re: Adding a Unique Index to COM:Company

2011-11-04 Thread Jase Brandon
.. Joe *From:* Guillaume Rheault guilla...@dcshq.com *Sent:* Friday, November 04, 2011 11:21 AM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: Adding a Unique Index to COM:Company ** I would not recommend that... next time he upgrades, he may run

Re: Adding a Unique Index to COM:Company

2011-11-04 Thread Joe Martin D'Souza
: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Adding a Unique Index to COM:Company ** Many thanks to all - and sorry for the slow thank you - I ended up doing what Guillaume suggested - one filter to check to see if the record exists, then a set fields to set a hidden field with the value

Adding a Unique Index to COM:Company

2011-11-03 Thread Jase Brandon
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

Re: Adding a Unique Index to COM:Company

2011-11-03 Thread Guillaume Rheault
@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

Re: Adding a Unique Index to COM:Company

2011-11-03 Thread Cecil, Ken
Sent: Thursday, November 03, 2011 4:15 PM To: arslist@ARSLIST.ORG Subject: Re: Adding a Unique Index to COM:Company ** Hi Jase, I am 99.% 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

Re: Adding a Unique Index to COM:Company

2011-11-03 Thread Melissa reed
You can create the unique index on the base form, when you take it out of best practice mode. From: Cecil, Ken kce...@hubbell.com To: arslist@ARSLIST.ORG Date: 11/03/2011 03:55 PM Subject:Re: Adding a Unique Index to COM:Company Sent by:Action Request System discussion

Re: Adding a Unique Index to COM:Company

2011-11-03 Thread Joe Martin D'Souza
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: arslist@ARSLIST.ORG Subject: Re: Adding a Unique Index to COM:Company ** You can