Hi Richard, apologies in advance for what could be a long question. I have used Access in the past and am reasonably comfortable with vba, but my database at work is handled by Foxpro for windows. (Has been for many, many years.) As it becomes more and more difficult to operate this, especially with multiusers, I have decided to convert it to Access 2013. My initial problem is with my customer table primary key which I maintain by code. I have a one row table, open permanently, with one of the fields, fldAccountnumber. To enter a new customer I increment the number in this field then put the result in the primary key field of Customer. Perhaps I made a mistake originally by using this field, showing it on invoices etc. I have quite a few child tables referencing this field. In transferring the database to Access 2013 it would be nice if could use this number (it is unique) and start my autonumber from the last number used in Foxpro. There are roughly 16000 records in the existing table. Do you have any part of the course that handles this?

Regards

Dave Hookings