OK we have a custom ticketing system developed in PHP/PostgreSQL. How it works now is that information is entered, click submit, ticket number is shown.What They would like, Ticket number shown, enter information, click submit.Now I know I can just create a blank record and use that record id then do an update when the user submits. I wanted to know if there would be a better/alternative way in doing this?Some key points:
record id is the pk, auto increments
record id's must be in order, no skipping record id numbers
The problem is a end user could start the ticket id process and not click submit which would result in a blank record. Which might be the best way to proceed.any ideas or is this the best approach?EDIT:I understand all the gripes and what I need to do to complete the requested action, looks like I'm just going to be dealing with blank records. It shouldn't happen to often but I wanted to see if anyone had to deal with this before. Thanks for the input
