Thanks Martin
I did the Table Inheritance with Two tables :
For example :
1. Base Table : Fields : StudentID, RollNumber, Class
2. Derived Table : Fields : Marks, Division
Steps :
1. In Base Table properties set to Support Inheritance = Yes
2. Then creating int64 field in Base table. Name the int64 field as "InstanceRelationType".
3. In Base table set the InstanceRelationType property to InstanceRelationType
4. and create few other fields as needed.
5, In Derived table , we are setting two properties Extends and Support Inheritance
6. In extends we set "BaseTable" and Support Inheritance set to Yes
****
Then i open Derived Table
I saw the fields from Base table is automatically populated in to Derived table.
It's showing fields in Derived table:
StudentID, RollNumber, Class,Marks, Division
Note : here StudentID, RollNumber, Class fileds from base table.
***** Then i am creating new records in Derived table .
Then i open Base table, i saw data is automatically replicated in the base table as we are created records in the derived table.
Note : I noticed two things :
InstanceRelatiponType holds "Table ID"of Base table which is also same in Derived table in field InstanceRelationType.
I think the field InstanceRelatiponType is used for making relation between 2 tables (Base and Derived).
Please let me know if i missed any thing?
Please give me more shed on this.
Arpan