Need clairification

Ok, the lightbulb has illuminated. Thanks I have been doing this kind of
database occasionally alll along, but I did not realize that this was the
term used to describe it.


"John W. Vinson" wrote:

On Sat, 9 May 2009 19:19:01 -0700, John F
wrote:

Ok, I sort of figured out that much but how would you implement this?

Set up your Items table with an ItemID primary key (Autonumber or other
datatype) and the fields pertinant to all items; and set up each subclass
table with an ItemID primary key. This should be a Long Integer if
Items.ItemID is an autonumber, othewise it should match. Each subclass table
would have fields for the proper attributes of that subclass.

For data entry you'ld use a Form with a Subform; one useful technique is to
change the subform's Recordsource to the (say) Software table if Software is
selected on the main form as the item type.
--

John W. Vinson [MVP]