Access 2000 auto number not giving right master record number.

M

Musicmanboggs

New database generates sequential master record number for each new entry.
All went well for first 74 entries.(1-74) When entering what should've been
75-80, auto number on subform table started generating huge non-sequential
numbers. Can this be fixed without starting over with new database?
 
K

KARL DEWEY

What I meant by "append by sorting on the field" was if you want the records
to be in the same order then you need to sort them as you append to the new
table.
Like this --
OLD NEW
1 1
2 2
through
73 73
74 74
77 75
79 76
80 77
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Number ID Field 4
stop auto number 8
Auto Numbers 3
Field to auto number from the highest plus one 3
Auto-number not working on front end 1
Contact Record Sort 2
Subforms and self populate number 0
Create ID with consecutive numbers by month 5

Top