Autonumber

C

creyno

I have a table that i wolud like to insert an autonumber
field in but this table allready has data in it with the
same customer info in multiple fields it is a delivery
database is there a way that i can create a table exactly
like it and import the info into it and have it autonumber
all duplicates so that each customer has it own unique #
so that searching it will be easier i am new at this so
any help would be appreciated.
 
V

Van T. Dinh

Sorry, no!

The whole purpose of AutoNumber is to provide *uniqueness* for each Record
in the Table and you want duplicated values for the AutoNumber.

It sounds like your Table Structure is not properly designed. Suggest you
check out Relational Database Design Theory and Database Normalization and
see if your Table Structure is correct.
 

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

getting an autonumber field to go beyond 3999 5
Autonumber 4
Primary Key Autonumber - Is it the best choice for discrete ID num 11
How do I do this in Access 2007? 1
2 tables, 1 query, 1 form, 1 subform 6
Avoiding Duplicate Entries 4
Managing autonumbers 1
Using a calculated Field instead of AutoNumber 5

Top