Alphanumeric "autonumber"

[Peter]

Hi all,

How do i obtain a alphanumeric "auto number" for each new record?

Thanks!

 

[Keith Wilby]

Hi all,

How do i obtain a alphanumeric "auto number" for each new record?

Thanks!

An AutoNumber's function is to index the record with a unique identifier and
should be of no interest or bearing to the end user, it shouldn't even be
visible. It is a numeric type and that cannot be changed.

If you describe what it is you're trying to achieve then I'm sure that
someone will be able to assist.

Keith.
www.keithwilby.co.uk

 

[Peter]

Thanks Keith, I want to issue two databases and in order to be able to
identify the source of the records I would like to assign different unique
identifiers..
Database 1. Standard auto number
Database 2. Alphanumeric record identifier

Perhaps I am thinking wrong?

Thanks!

 

[Keith Wilby]

Thanks Keith, I want to issue two databases and in order to be able to
identify the source of the records I would like to assign different unique
identifiers..
Database 1. Standard auto number
Database 2. Alphanumeric record identifier

Perhaps I am thinking wrong?

Thanks!

You could have a single character text field to identify the source and a
number field for the unique number, then concatenate the two in a query.
The number field could be populated by using DMax in the default value to
find the next available number.

Any mileage in that for you? You'd still use (for example) an autonumber
for indexing and relationships.

Keith.
www.keithwilby.co.uk