How do you reset auto number in a table query?

Hello,

I am testing a table structure, and want to delete all of the records,
which are primary keyed with auto number. If I just delete the records,
and create a new record, it picks up whatever the last record number
was. I remember once that I had to do a query to clear that index. BTW,
does it make any differnce if the primary key is indexed (duplicates
OK?)

TIA.

Phil.

.

Relevant Pages