I need to create a unique ID ("SupplierCode.xxxxxx") where SupplierCode is one of the columns, the sequential number is generated on a per supplier basis.

Any ideas? (Hope the above makes sense)