Change ID field

[Joe]

I am creating a new database to track inventory within my group. We all are
issued a unique ID number from our company, so how do I get that number to
show in the ID field instead of the order that each name is input?

 

[Maarkr]

We all are issued a unique ID number from our company, so how do I get that
number to show in the ID field instead of the order that each name is input?

Do you mean that there is a specific format to use for the ID numbers?
Instead of autonumbering like 1, 2, 3, 4... do you have a system like
XYZ09001, XYZ09002, XYZ09003... explain pls. You will need to add your
CO_ID field to the table, then give us the format and sequence and we can
help you with a formula to use to autoincrement that field.

 

[Jeff Boyce]

Joe

I can only guess, based on your description, that the ID field you are
referring to is an Access Autonumber field. This is a unique row identifier
that is generally unfit for human consumption.

If you have a company-issued ID/code for each individual, one approach would
be to add a new field to the table to hold the CompanyID value.

Regards

Jeff Boyce
Microsoft Office/Access MVP