Question how to make auto generate receipt no and invoice number in data bindings

[master_2013]

how to make auto generate receipt no and invoice number in data bindings with ms access

 

[jmcilhinney]

You can set the primary key column to data type AutoNumber and it will generate a basically sequential number each time you insert a new record.

 

[jmcilhinney]

Check out this thread for an example of how to retrieve the generated values via a table/data adapter and a DataTable.