About the only two things I use the autonumber for is first to give a unique number to all records for joining databases. I also use it for easy fast access to records that I want to make updates to. On my input form I can enter the autonumber (which I print on all phone center reports) so I can update information quickly. In the call center we have to check 3 things, did we get a survey, was the survey denied (ie person called said pack sand), and to mark a number as no good. In the last two cases it tells the computer to drop the phone number from the Table to we don't waste our time calling someone over and over. When we get a good survey, that is also auto updated with a check box field so we know to add that survey to the main system, and use the data for statistical reports for the companies we do surveys for. Also if we do nothing with the call, ie busy signal, no answer, etc then the computer will periodically try the number again. But to answer your question, I would not want to use autonumber in that way. Anytime autonumber is used, it waits till the record is saved to fill the box, because otherwise you would end up with hundreds of autonumbers in empty records. Hope this helps. (Signed Old Stone Face)
Robert Taylor
|
