Hey all, I have a small problem. I am using ASP Upload to upload files into dynamically created directories. The form which I have created to do this needs an Order Number attached to it (which the user can see as well as it being emailed to the client).

I have set up a column in my DB (Access) called "ordernumber". My question is "How do I extract the Order Number from the DB into the form when the Order Number hasn't yet been created (because the order hasn't been inserted)?"

The only way I can think of getting around this is not having an Order Number on the insert record page and instead have it displayed on the Order Confirmation page. Would this be the best way of doing it?