I have the attached sql server 2008 db design. The basic concept of the design is to store contract agreement information for companies wishing to purchase software tools from us, i.e. A parent company (Microsoft) will have child companies (Microsoft UK, Microsoft US etc). Each child company will have key contacts for correspondance reasons (Financial Contact, Technical Support Contact etc). Each child company will also have contract agreements with us in regard to purchasing our software tools, now I would like to structure my uniqueid values (AGRID and AGRADID) at this stage to accomodate for relevant business logic. I would like AGRID to remain as a unique int value but of the format "0000001 - 00" if possible? i.e. First row: 0000001 -00, Second row: 0000002 - 00 etc. The next unique value I would like to format is AGRADID, here I would like it's value to be of the format "<AGRID> - 01" i.e. First row: <AGRID> - 01, Second row: <AGRID> - 02 etc while obviously upholding the relationship rules between these tables. Is this achievable through some sort of seeding rule or computed value? Or can my db design be somehow altered to achieve this?