Classification: UNCLASSIFIED Caveats: NONE Hello Bola,
Another way to do this if you are restarting a form is the following: NOTE: Always try this on a copy of the form first. In other words, TEST it first!!! 1. Make sure you have a good backup of the system (should be a normal thing which is done every night) 2. Backup the form and all it's workflow to a .def file (for safety and reuse) 3. Backup any significant data to a .arx format (Actually, I believe you can do steps 2 and 3 using XML but I haven't done this so I fall back on old school) 4. Delete the Form using the Admin tool (Note: this will delete all data and all the workflow) - this also drops it from the arschema table. 5. Reload the .def file (the new Request Id will be reset to 1) 6. Reload the data, but make sure it creates a brand new Request ID (see mapping controls) - if you want to retain Request IDs you'll have to do it with another mapping) You can also perform the SQL updates provided in previous emails, but you probably do not have DBA privileges, so the above will work. Sounds like from you description, you don't need the data. This is very old school and uses just the ARS system. Too often Remedy Admins fall back on SQL when you really don't have to go to this level. Just make sure you do this in a TEST mode first. Gordon M. Frank Verizon FNS -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Oyefeso, Bola Sent: Monday, November 05, 2007 9:33 AM To: arslist@ARSLIST.ORG 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 __20060125_______________________This posting was submitted with HTML in it___ Classification: UNCLASSIFIED Caveats: NONE _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"