Please help! I'm going mad!

[benzo1]

Essentially, I am copying and pasting data from one table to another. Autonumbering should assign a new number for the data.

What I have found is that if I delete many records from the table which records are to be copied into, it autoassigns a number to the new records as if the records I have deleted are still there.

ie,

Table A has 20 records. I delete 5. Therefore, there should be 1-15 records. I add another 20 records, it autoassigns the first records of the pasted data 21!!!

I am going mad! please help me!

Thanks.

Benzo1

 

[MichaelRed]

instance Help.

keyword "autonumber"

read.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[sumoalex]

I've never found a way to reset that either (wish I could!). Basically once that number has been used, it's there forever. The only way to have always have a difference of one from the previous is to code it yourself rather than use Autonumber.

 

[MichaelRed]

SUMOALEX

read the above post. follow the direction. all you need to know is there.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[sumoalex]

I did. Read MY post. I got it from Access help as you suggested. You CANNOT delete an autonumber.

 

[MichaelRed]

SUMOALEX

a.[tab]you are mostly 'correct'. 'autonumber' is intended to UNIQUELY identify a record.

b.[tab]re-assignment would RATHER OBVIOUSLY defeat that intent.

c.[tab]if you carefully read the reference info you should be able to see a minor exception or so.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places