I have five tables, one for beneficiary's biographic info and other four are for spouse and three children biographic information. The beneficiary's primary key is the foreign keys for spouse and children. And also Spouse and children have their own primary keys.
1. Am I doing correct?
2. And also I have seen in some examples in this forum, in the relationship window, connecting primary key with other foreign keys. ( tiny lines connecting tables ) and referential integrity is enforced. Is it necessary? Having a drop down in the form and set properties limit to list is not enough?
3. If relationship window connection is mandatory or necessary in RDBMS, how do I use it.
Thanks for your help.
1. Am I doing correct?
2. And also I have seen in some examples in this forum, in the relationship window, connecting primary key with other foreign keys. ( tiny lines connecting tables ) and referential integrity is enforced. Is it necessary? Having a drop down in the form and set properties limit to list is not enough?
3. If relationship window connection is mandatory or necessary in RDBMS, how do I use it.
Thanks for your help.