Creating a Trouble Ticket

From: minor07 <>
Date: 3 Feb 2003 00:36:12 -0800
Message-ID: <>

i´m just stucking in creating a troubleticket and dispatch db. What our copany wants to implement is every time a customer reports a new trouble a record in the following format should be created:

SA (always SA); Year (eg 03); Moth (eg: 01); Day (eg 23); runníng Number from 000 to 999

--> SA030123003

Any idea how to implement the running number or the service request? Thanks in advance.

TOM Received on Mon Feb 03 2003 - 09:36:12 CET

Original text of this message