Here are the details to two versions of Product Tables, one for Access 2000/97 and one for SQL Server 7. Not all of these fields are necessary in one database. For example, with Size and color you can ...

But if you want your autonumber field to start at 1 then you could just delete your current autonumber field and then put it back in again. That renumbered the autonumber field for me.

I am saving a record to a database on SQL server 2k that has a field 'id' -- it is an autonumbered/identity field and thus auto-increments as necessary when saving records.At any rate, this is the ...