Tags: access, auto, contact, customer, database, default, entered, microsoft, mysql, number, oracle, own, sql, syste, system
HOW CAN I CHANGE THE CONTACT ID AUTO NUMBER TO MY OWN NUMBER SYSTE
THE CONTACT ID USES AUTO NUMBER BY DEFAULT.
I WANT TO USE MY OWN CUSTOMER NUMBER OR LETTER SYSTEM.
HOW CAN I CHANGE THIS? OR CAN I AFTER I HAVE ENTERED IN MY CUSTOMERS?
Leave a comment...
- 1 Comments
- (Please use proper case when you post. It hard to read when everything is
in CAPS. Capital letters are considered as "shouting" in newsgroup
You cannot change the values of the AutoNumber Field!
Create your own "CustCode" Field (of Text type or Long type depending on
your requirement) and set this Field as the Primary Key of the Table. You
can then enter unique CostCode as required.
Van T. Dinh
"PC" <PC.ms-access.todaysummary.com.discussions.microsoft.com> wrote in message
> THE CONTACT ID USES AUTO NUMBER BY DEFAULT.
> I WANT TO USE MY OWN CUSTOMER NUMBER OR LETTER SYSTEM.
> HOW CAN I CHANGE THIS? OR CAN I AFTER I HAVE ENTERED IN MY CUSTOMERS?#1; Fri, 30 May 2008 11:32:00 GMT