Autonumber Alternative

[Guest]

I want to create an automatic unique identifyer for my table in the format
AAA-000. I have found that the autoformat datatype cannot have formats apart
from long integer and replecation ID. I have also tried changing data type to
number and inserting - "AAA"-000 - in format. This appears ok but does not
automatically increment like autonumber does when a new record is created.

Any ideas or not possible?

Thanks

 

[Rick B]

If this is a number that has some meaning and needs to be incremented, then
you will have to create code to do so in your data entry form.

Do a search, this is asked and answered all the time in the forms,
formscoding, or tabledesign newsgroups.

 

[Mike Painter]

I want to create an automatic unique identifyer for my table in the
format AAA-000. I have found that the autoformat datatype cannot have
formats apart from long integer and replecation ID. I have also tried
changing data type to number and inserting - "AAA"-000 - in format.
This appears ok but does not automatically increment like autonumber
does when a new record is created.

Any ideas or not possible?

Thanks

If it's always "AAA" then use a query and "AAA" & YourAutonumber.
If not you will have to write code to increment the number and the letter
sequence.

 

[Davide]

ciao