How do you implement subtype tablewith attribute inheritance in ac

[smit127]

I want to implement library for loanable items. A rental item table exists
which contains the bulk of the attributes but there are subtypes of this
being DVD, video and computer game which each contain specialized
information. When I add a DVD for example I want to add all the attributes
inherited from item plus the specialized attributes in DVD e.g. director, DVD
release. How can I do this in access?

 

[Sprinks]

Hi, smit.

Assuming you have a table that contains this specialized information, you
already have access to it via a query. It IS NOT advisable to try to store
this supplemental information redundantly in your Rental table. It is
already stored in one authoritative place that you have Access to. (pun
intended)

To *display* this information on your form, or in a report, etc., include
these fields in a query, linking on the ProductID, and place controls bound
to these fields on your form and/or report.

Hope that helps.
Sprinks