Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004

    SuperType / SubType Question

    Hi All,

    I know this is a DB specific question but I posted in the Access forum and didnt receive a reply. I hope no one has an issue with this post, if so I will withdraw it.

    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.

    I can do it easily with Oracle designer but I am relativley new at developing with Access.

    Any help would be appreciated.


  2. #2
    Join Date
    Dec 2003
    You may try using Oracle designer and generate the DDL. Then use the DDL to guide you as to how to code a generalization hierarchy for access.

  3. #3
    Join Date
    Sep 2003
    The extremely Royal borough of Kensington, London
    I do not believe sub-types are represented explicitly in design view in MS Access, because there are different options to physically represent the implementation. For example:

    1) Single table
    2) Master + details
    3) Collection of detail tables.

    Once you have decided on your implementation method, the relationships can then be constructed accordingly.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts