Setting Naming Conventions for IDs

[LukeJ Innov]

Hello all,

I am wondering if it is possible to set a naming convention for auto numbered records?



For instance in a table that holds information on customers, could you start the auto number scheme at something like 'cust01' rather than the normal autonumber scheme that's starts at 1 and continues.

Just so I am absolutely clear, table could be:

Customer_ID	First_Name	Last_Name
cust01	Ben	Robinson
cust02	Dom	Rodgers
cust03	Lilly	Balentine
cust04	Luke	Teal

rather than the normal:

Customer_ID	First_Name	Last_Name
1	Ben	Robinson
2	Dom	Rodgers
3	Lilly	Balentine
4	Luke	Teal

Thanks,

[orange]

You could, but what is so important about Cust?

If the autonumber is important to you, and not just the underlying data base management system, then perhaps you are working with the wrong data type.
Here's some info on autonumber

I would suggest from a field naming point of view that you include some indication of the table, as you have, when naming the ID Field.
CustID, ProjectID, ProductID etc, rather that a bunch of ID's with no context.

But I don't see any business rationale for the data value itself to include "Cust"...