| 1. |
How To Maintain Referential Integrity Among Tables ? |
|
Answer» In Maintain Table definition against each table field we can maintain the referential integrity to another table. You can maintain the reference table, reference mode and reference message (in case of any errors). If a normal field refers to a table, the primary index of that table must CONTAIN only ONE part with the same DOMAIN as the field. If a combined field refers to a table, the DOMAINS of the child FIELDS of the combined field correspond to the domains of the parts of the primary index of the table. In Maintain Table definition against each table field we can maintain the referential integrity to another table. You can maintain the reference table, reference mode and reference message (in case of any errors). If a normal field refers to a table, the primary index of that table must contain only one part with the same domain as the field. If a combined field refers to a table, the domains of the child fields of the combined field correspond to the domains of the parts of the primary index of the table. |
|