Records
Child tables may have both standard and child records. Only a child table may have child records. A child record is identified by the combination of the parent record key and the child record key.
Standard Record
A standard record can be added to any of the table types. When added to a parent table, a standard record becomes a parent record. However, if added to a child table, a standard record remains a standard record. It is never linked to a parent record.
Parent Record
A parent record is a standard record with the additional feature that it allows child records to be linked to it. Adding a record to a parent table makes it a parent record. Therefore, all records in a parent table are parent records. Standard and child tables cannot hold parent records. Add, update, and delete operations are performed in exactly the same way as for standard records. Parent records can have multiple child records.
Child Record
A child record is a standard record with the addition of a parent record key. A standard record has a single key value that forms the unique key for the record. A child record has two key values: the record key and the parent record key. The combination of the two forms the unique key value for a child record. A child record has only one parent key value.