I'm a developer treading into the database world so bear with me please.
I'm creating a Contract database with separate tables for various types of contracts.
I have 5 tables but would like to share a common 'Identity' field between them, so that there will be a unique contract # for any given contract regardless of type.
What is the recommended way to do this? Something that won't over complicate simple crud transactions?
My application will be using a Sql Server 2008 R2 server..the app itself is Silverlight 4 using WCF Ria services for CRUD transactions.
A schema idea would be great, a tutorial of something similar ideas and technology would be even better.
Thanks for looking Robert