One-to-Many with Inheritance Relation
A one-to-many with inheritance relation is similar to the 1:M relation; however, it allows the child to see and populate all the members of the parent.
Relation Example 5
Insert into the child of 1:M with inheritance relation on a blank database.
Insert Dog (DogName="Spot", DogBreed="Cocker Spaniel",
DogOwnerName="Bob", DogOwnerAddress="Redmond")
Table Dog
| DogID | DogName | DogBreed | DogOwnerID |
| 1000 | Spot | Cocker Spaniel | 1000 |
Table DogOwner
| DogOwnerID | DogOwnerName | DogOwnerAddress |
| 1000 | Bob | Redmond |