Alphanumeric "autonumber"

  • Thread starter Thread starter Peter
  • Start date Start date
Peter said:
Hi all,

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

Thanks!
Click to expand...

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
 
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!
 
Peter said:
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!
Click to expand...

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
 
Back
Top