jonathanchye
Registered User.
- Local time
- Today, 16:09
- Joined
- Mar 8, 2011
- Messages
- 448
Hi,
I am wondering if it would be possible to apply a mask to an autonumber field and also have it to start at a custom number?
For example, I would like my PK field "InvoiceNo" to start from IV8888 and autonumber from then on...
I am trying to create a field that starts with a number for ex 8887 and then create another field that adds 1 to the field and apply a "IV" mask but I can't get it working for new records and it won't accept being a primary key...
I am wondering if it would be possible to apply a mask to an autonumber field and also have it to start at a custom number?
For example, I would like my PK field "InvoiceNo" to start from IV8888 and autonumber from then on...
I am trying to create a field that starts with a number for ex 8887 and then create another field that adds 1 to the field and apply a "IV" mask but I can't get it working for new records and it won't accept being a primary key...