Bola, Find out the schema ID of that form, you will be able to find this from the table arschema.. Corresponding to that row in the arschema table, modify the nextid value to 1.
Also make sure that you have deleted all related tickets in case you have related information stored in other tables. Reset those ID's as well. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Oyefeso, Bola Sent: Monday, November 05, 2007 9:33 AM To: [email protected] Subject: Starting a new ID ** Hello everyone, I created some tickets on a new application that I am implementing tomorrow. I will be deleting all these tickets, but I want the user to begin with Case ID “00000000001”. Any quick idea on how to do this? Thanks all. Bola Oyefeso No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.22/1111 - Release Date: 11/5/2007 4:36 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<<image001.gif>>
