I'm working on an asset tracking db for our use in house. Very simple structure.
tblClientGeneral has a client_id and a client_name. tblAssetTag is linked by client_id 1-M.
I originally was using autonumber random to generate the a unique asset tag but realized quickly that that can give a negative number and also it's not exactly good practice.
Now i'm a little stumped. My primary key is just an id field. So what is the best way to create a field that will generate an auto increment number for my asset tags. They must be unique. I'd like 8 digits with no preceding 0's and all positive.
I've seen a few things but I'm not sure what is the best way to go about this..
Thanks
Bruce
tblClientGeneral has a client_id and a client_name. tblAssetTag is linked by client_id 1-M.
I originally was using autonumber random to generate the a unique asset tag but realized quickly that that can give a negative number and also it's not exactly good practice.
Now i'm a little stumped. My primary key is just an id field. So what is the best way to create a field that will generate an auto increment number for my asset tags. They must be unique. I'd like 8 digits with no preceding 0's and all positive.
I've seen a few things but I'm not sure what is the best way to go about this..
Thanks
Bruce