I am trying to build a confirmation number system/ordering system that takes user input and loads it into a database. I have built the ordering system already and that is fully functinal, but I am trying to decide the best way to build a confirmation number system that is tied to the ordering system, handing out confirmation number's when a customer places an order. Additionally, I want this confirmation number loaded into the database for future reference.
Any ideas?