Let me explain what exactly we are trying to do.
Waste Hauler Unique Number Example: 00000-V/C 0000- AT- YR
Requirements:
Hauler # = 00000 (permanent)- there may be 1000 hauler companies
Asset = V / C (vehicle or container + permanent #)
Material/Classification = AT (landfill / temporary)- this may be different
(Material: A- Landfill B-Recycling C-Compost)(Classification: T- Temporary P- Permanent)
YR = Year (2013)
So the best way to implement this is to use the Identity Property? Is that correct?
I just need to know a logical way to implement this.