Autonumber question

[Holmes]

Ok, I have a lovely database setup for call loggin.

I have a table that contains a primary key [autonumber], with all the details about a call e.g time of call [time short] date of call etc.

I would like to add a call refernce field that is automatically generated for each new record. But I don't want just a number, Ideally I would like it to
be preceded by something.

So when a new record is opened the reference becomes aa002301. When another is opended it becomes aa002302.

Any ideas on how to do this?

Is there a way to change the primary key so that it becomes the refernece?

Many thanks in advance for any help.

B.

 

[RichardP1978]

Is there data in other tables that relate to the autonumber that you want to change about?

 

[Holmes]

Hello,

There are no links to other data from the auto number.

I just can't see how to format the number in the way described above!

B

 

[Bat17]

if you care what the numbers are in an autonumber field then you are probably not using it correctly

Autonumbers on guarantee a set of unique numbers not consecutive ones. if a record is canceled/deleted/pc crashes before record is saved you will get a gap.

Peter

 

[Holmes]

ok, I'm doind something different now, thanks.