autonumber problem

G

Gerald

dears,

I have test 1 and test 2 table with 20 records each. test 1 and test2 are
linked with one-many relationship.. it has a field for autonumber e.g. fieldx
presently the fieldx is at record no.20. now when I want to enter real time
records, I do no want the 20 records since its just samples. When I delete
the 20 policies, and try entering new real time record, the fieldx shows 21,
not 1

any advice

thanks
 
J

Jeff Boyce

Gerald

The Access Autonumber is intended for use as a unique row identifier. It
isn't really fit for human consumption. It really doesn't matter what
"starting value" it has. If you are displaying the Autonumber value,
consider creating an ID that you can more directly control, as Autonumber
may not be suitable.

Depending on version, you may be able to empty the records, then Compact &
Repair the database to get back to 0.

Good luck

Jeff Boyce
<Access MVP>
 
G

Gerald

I have MS-Access 2000, but when I run Help>>>Detect& Repair, it asks for
DATA1.MSI file from the Office 2000 CD, which I don't have.

any other ways to sort this

Thanks, Jeff
 
Top