I have written a VB .net app (Windows) using an SQL server back end that service technicians use to log service calls from customers. Everything is working except one point I hope you can help me with.
When a Tech answers a call he wants to open a screen that has a unique number we will call "Case number". The tech will tell the customer "Your case number is..." The tech may spend a few seconds, or an hour on the call.
When he is done he will click a button to save all the data filled out on the screen.
Since many techs will use this at the same time, it is very probable that another other techs will be doing the same thing at the same time, and the case numbers must be accurate.
My first inclination is to creat an identity column in the table and use that number as the case number, however the only way I know to "hold" that number is to insert a blank record in the table. That's OK, but if a customer hangs up, or the tech opens the window by mistake my table will be littered with blank records.
Before I embark on that route is there some slick built in function or trick that you can recommend to accomplish my task ?