• 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.