Making an autonumber field start at a set number
- From: "RASTUS" <rcuf@xxxxxxxxxxx>
- Date: Tue, 31 Jul 2007 07:26:39 +1000
I am constructing an order number and a Job number based database and I want
the order numbers to automatically increment to the next number, I currently
have used a combined key to achieve this but don't know how to make both
parts of the key display on the form and don't know how to make the number
increment starting from a given number say 550000, can anyone help, possibly
I should not use the key field to achieve the desired effect?
.
- Follow-Ups:
- Re: Making an autonumber field start at a set number
- From: salad
- Re: Making an autonumber field start at a set number
- From: Larry Linson
- Re: Making an autonumber field start at a set number
- Prev by Date: Data Conversion Help
- Next by Date: Re: Null values on crosstab query
- Previous by thread: Data Conversion Help
- Next by thread: Re: Making an autonumber field start at a set number
- Index(es):