On Wed, 2007-01-17, [EMAIL PROTECTED] wrote
We are having 3 tables;
1. persons -- Base table and no data will be inserted in this table.
2. Person1 -- Inherited table from persons all data will be inserted
in this table.
3. PersonalInfo -- which is storing all personal information of the
Hi,
We are having 3 tables;
1. persons -- Base table and no data will be inserted in this table.
2. Person1 -- Inherited table from persons all data will be inserted in this
table.
3. PersonalInfo -- which is storing all personal information of the persons
and is having the foreign key
Currently foreign keys don't work that way. You will need your data to be in
table persons if you want the foreign key to work correctly. Otherwise you
could create your own trigger to ensure the foreign key restriction you need.
I'm no expert at all and it seems there are non trivial issues