Quote Originally Posted by citldba
Yes, that looks like the sort of thing we have been talking about
Okay, good!

Is there a need for each Sub-Type Table (e.g. Telephone) to have its own PK (e.g. "TelephoneID") plus a FK (e.g. "ExpenseID") to link back to the Super-Type Table (i.e. Expense), or is it okay to just have one ID field that is both a PK and FK?


Just Bob