How does one show SuperType / SubType relationships in MS Access 2000? I need to show the following supertype - tblCollection which is an associative entity containing the common values for the subtypes such as fkValueId for tblValue and fkConditionId for tblCondition. Examples of the subtypes are tblComicBook and tblCoin which each have their own unique values that the other collections do not have. There will be many different types of collections so making tblCollection one big associative entity is not feasable or scalable.

Any help would be appreciated.