Inheritence woes

Hello All,
We've been playing with Inheritence and have perhaps not used it
correctly.

Our original intention was to have a generic table called unit, then we
dealing with different types of units, like boats, or cars, or marine
outboards for example, they can then inherit off unit and get a common
set of attributes.

As we've progressed things like the purchase costs for these items needs
to be recorded and we've added in a table like, unit_purchase_cost.
However, because the unit type car inherits unit, unit_purchase_cost
can't use a foreign key that references unit.id because the values are
in car.

Doing a SELECT * FROM ONLY unit; shows no values as they're all in car.

About the only away around this right now we can see is to write our own
foreign key triggers, allowing the insert of the value without the
referential integrity to the parent class?

Any other thoughts on this?

Thanks.
--
Hadley Willan > Systems Development > Deeper Design Limited. +64(7)377-3328
hadley(dot)willan(at)deeperdesign(dot)co(dot)nz > www.deeperdesign.com > +64(21)-28-41-463
Level 1, 4 Tamamutu St, PO Box 90, TAUPO 2730, New Zealand.