In access I had a table with a primary key set to auto update and uni records. When you would enter a new record this field would update with a new number. In SQL I have the same primary key the data type is set to var and I have the identity set to yes and increments to 1. When I start a new record it does not auto update this field with a new number?
Why?
jon
Why?
jon