Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2009

    Unanswered: Subtype/Supertype relationship in Access

    Hi I am trying to create a super/subtype relationship in access Here is my small scenario I have Super type boat with PK boat name then i Have sub types of fishing boats sail boats dive boats etc these all have PKS like Boat Name Fishing, Boat Name Sail. when I try to create the relationship in access it shows I drag the super type boat name to the subtype boat name fishing it creates a one to one relationship is this going to work for what i need? I attached a shabby er diagram to help with a visual
    Attached Files Attached Files

Posting Permissions

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