Help needed with a unique number ? (2 Viewers)

[Gnmrad]

I am very new to access (clueless), i have workticket database which has all the workticket connected to many workticket detail, I need to make this workticket that when i want it to print to a delivery note i type in the quantity delivered and then when printing a unique number is produced , the number increments by 1 but does not run in the same order as the workticket, i am not sure if i should have another table for deliverytable. the worktickets can be closed randomly but the delivery not has to run +1 after each other in increments. I am using a form to search for the workticket then i type in the delivered quantity and then print which then closes the workticket and give me the delivery note number which only happens when i say close workticket y/n. No delivery note number until closed. Any ideas will help do i need a special delivery table separate from workticket , which seems i am duplicating data. If this sounds confusing then its confusing me.

 

[GPGeorge]

Over the years, a number of discussions here have included methods of implementing unique, sequential numbering.

Search results for query: unique sequential number

 

[arnelgp]

to make it simple, just add a Delivery table.
will hold the DeliveryID (Autonumber), WOTicket, DeliveryQty, DeliveryDate

use combobox to select which WoTicket on the form.