Hi there,

I'm fairly new to the field of database design, my professionalism is in internet solutions but i hope someone can help me out with this one. If you have some questions about internet solutions just e-mail me.

I have designed a database in Access 2000 and then upgraded it to a pre-installed SQL Server (done by someone else). Only now the 'autonumber' from Access was transformed into an 'identity'. But the real problem is that my database was based on first getting an ID. Now i first have to fill in the fields to get an ID afterwards :-S

Can someone help me out how i can get an ID when something is first entered, just like Autonumber from Access 2000?

Many many thanks,

Paul