displaying autonumber in a textbox
-
if the OrderNumber is an autonumber(as opposed to text) in the Order table of the database, is it possible to display this number in a textbox on loading of the order generation form? Thank you in advance!
I have doen this in the past by using a separate table that only contains the autonumber feild and a column for a username. I add a new record to the table (by writing the username), to get a new invoice number, then a run a querry that grabs the top 1 from the list with that username. I then use that number in the table that contains the invoice data. Seems to work quite cleanly. Not sure just how leagle it is with regards to DB theory, but it has worked in the past.
Paul Watson wrote: "At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote: "Don't sweat the petty things, and don't pet the sweaty things."