Re: Creating a Trouble Ticket
Date: Thu, 6 Feb 2003 09:19:37 -0000
"--CELKO--" <71062.1056_at_compuserve.com> wrote in message
> >> Any idea how to implement the running number or the service
> request? <<
> One idea is to build a table of ticket numbers, like one of those
> bakery shop machines with the tear off paper tickets.
What an easy, yet simple and effective solution!
I frequently come across great simple solutions like this. Other solutions have involved creating a Sequence table to dish out Invoice numbers that need to be sequential and a table to hold system settings Settings(Setting VarChar(20), Value VarChar(100)).
Stu Received on Thu Feb 06 2003 - 10:19:37 CET