Hi guys,

So basically I have a form on VB that adds data to a database... one of the fields in the database is called 'leadid' in the database structure it is not an autonumber.

throughout my project it makes reference to the field 'leadid' and other tables have fields that are identified by leadid.

Unfortunately when building the database i forgot to set leadid as autonumber... and then imported my sql database into microsoft access (this was to have all the existing data on the new database)

When using my form to add a new lead to the database, it needs to add a number to leadid. Is there anyway of doing it without having autonumber and without using an existing number being used?

As microsoft access wont let me change it to autonumber...

Thanks
Jamie