auto enter serial number
I am working on a database offering services to individuals.
At the end of the month I make a summaries by individuals ( the result of a query ) of the services; which I then use as an invoice.
Each service given has an ID number but I have been asked for an invoice number.
I have an invoice number field on the layout and I have tried different ways of auto entering a serial number in this field but no luck yet. Any help would be greatly appreciated.