Autonumber

  • Thread starter Thread starter creyno
  • Start date Start date
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.
 
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.
 
Back
Top