Auto Number Field Problems

[claddagh]

Hi guys,

Just a quick one ( I think )

I have a table which already has an autonumber ( the id field )
But I need to create another field also with an auto generated number which will generate reference number which i need to start at a pre-defined number.
The problem is, im not allowed to use 2 auto number fields, and access is prompting me to use a number field instead.

The question is, is there a way around this ?
Can i create another field which works the same way as an auto number and increments the number by 1 for each new record entered ?

Many thanks in advance for any help.

Max

[edit: spelling mistakes]

 

[neileg]

You shouldn't use an autonumber for numbers that mean something. You can easilly get gaps in the sequence. Search in these forums and you will find that generating your own number is a regular topic.

 

[claddagh]

Autonumber

Ok thanks,

I`ll have a search and see if i can find anything.
thanks for the advice

Max