Table inheritance - 'Is a' relationship


#1

Is there a way to setup ‘is-a’ relationship among tables?

ex: We have a Person table with atttributes like email, name etc.
We want to setup Employee table that inherits all attributes of Person but has more attributes like salary etc.

Is it possible to setup “Employee is a (Inherits from) Person” relationship?


#2

No, you can’t. I think you have 2 options here:

  1. Merge that information in Person table, using Views to Hide the fields you don’t want and Filter the records.
  2. Use Lookup fields to reflect the inherited data.

Based on the nature of the base one or the other could be better.