I am busy working with a program but i have a problem.
I am working with job numbers and each job number is for a specific place.
81101254 - Component Shop
84101234 - Workshop (new job number here!)
81601222 - Service Dept.

NOTE that the first 3 figures differ for each department.
What must i do to create the next job number for the workshop etc. 84101235

Say I want to click on an option button and then my program must see i want to create a new job number for the work shop.

It must then update the appropiate field in the database(access)and diplay the newest job number to me in vb - odbc connectivity is used with vb6.

Any help will be appreciated.