J
jbphoenix
I have a form to enter RMA data. I need to start my numbering at 4000
without using an autonumber. The ID field is text and cannot be changed.
The Customer_Order table is a linked table. A letter is going to be added
infront of the ID depending what the user chooses from a combobox. The
letter(R,A,C) signifies what type of transaction it is. Here is an example -
R4000
A4001
A4002
Currently there are about 100,000 records in the database but none with an
ID between 4000 and 10000. The majority of the records have a letter
preceeding the number. Any ideas on how to start numbering at 4000.
without using an autonumber. The ID field is text and cannot be changed.
The Customer_Order table is a linked table. A letter is going to be added
infront of the ID depending what the user chooses from a combobox. The
letter(R,A,C) signifies what type of transaction it is. Here is an example -
R4000
A4001
A4002
Currently there are about 100,000 records in the database but none with an
ID between 4000 and 10000. The majority of the records have a letter
preceeding the number. Any ideas on how to start numbering at 4000.