Autonumber question (1 Viewer)

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.

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

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

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

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