Re: help, help, help

[Baxter, Andrew]

** Sara, You can create the unique index within the form.  Use the online help and search the index tab for Unique.  This will explain that procedure to you.   Thanks, Andrew Baxter Manager, Information Technology w. (781) 902-6026 f. (781) 902-6002 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Scott Ames Sent: Tuesday, August 22, 2006 11:01 AM To: arslist@ARSLIST.ORG Subject: Re: help, help, help   ** Wow you are quick on the draw. I was composing a similar message when yours came in. lol. "Nall, Roger" <[EMAIL PROTECTED]> wrote: ** Sara,   To enforce unique values in a field I would suggest a unique index. As to a ‘Request ID’ type field you may need some sort of a stored procedure for that.   HTH,   Roger A. Nall OSSNMS Sr. Remedy Administrator/Developer T-Mobile USA Desk: 973-644-3963 Cell: 973-652-6723 FAX: 973-267-6628 sf49fanv     AIM IM RogerNall   Yahoo IM   From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of sara abate Sent: Tuesday, August 22, 2006 10:46 AM To: arslist@ARSLIST.ORG Subject: help, help, help   ** I am a new remedy developer and I need help on two of the following things,      1.  I want a field to have unique value.  How can I restrict the field from having duplicate values?  In other words, Is there any way I can block if the current value entered is already in the database?       2.  I want to create an auto generated field.  Anytime a ticket is submitted, the field should be populated automaticlly in increments.  In other word, I want a 'Request ID' kind of field on the form.      Anybody can help me with this please email me at [EMAIL PROTECTED].  I will appreciate it.   Thanks!      Sara   Do you Yahoo!? Next-gen email? Have it all with the all-new Yahoo! Mail. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ ****This e-mail is sent by Hudson Highland Group, Inc., or one of its subsidiaries, and may contain information that is privileged or confidential. If you are not the intended recipient, please delete the e-mail and any attachments and notify us immediately.**** __20060125_______________________This posting was submitted with HTML in it___