Trying to understand inheritance
Posted: Sat 02 May 2009 19:05
In a legacy database I have a customer table and a contact table
Customer Table
InternalKey
CustomerID
Name
PrimaryContact_InternalKey
Contact Table
InternalKey
Customer_InternalKey
Name
Etc.
What I think I should be able to do is put the contact table into the model once and then inherit from it twice once for PrimaryContact and once for all Contacts.
Does anyone have an example showing how to work with the one contact table in two different contexts?
Customer Table
InternalKey
CustomerID
Name
PrimaryContact_InternalKey
Contact Table
InternalKey
Customer_InternalKey
Name
Etc.
What I think I should be able to do is put the contact table into the model once and then inherit from it twice once for PrimaryContact and once for all Contacts.
Does anyone have an example showing how to work with the one contact table in two different contexts?