I'm designing a database structure wherein I like to apply the concept of inheritance.
base tables and
derived tables in which the relationship is one-to-one. I'm quite new as of how could this be achieved and how the data are to be fed to the tables because I'm getting errors I can't solved.
I'm wondering if I'm on the right track doing this.
Here's the design view of the database:
I get the error of
You cannot add or change a record because a related record is required in the table **PatientRegular**
In which case the table I'm on currently working?
And the relationship view:
What is the right way to do that? I want to inherit all those similar fields to another table?
Either way, I cannot also insert new data in the base table (I must be in a wrong track)