Custom records
Now that we've seen custom fields, what are custom records? The easiest way to understand customer records is to expand on our previous example, recording the name of a contact's spouse on the contact record. Let's assume we also need to record the names of the contact's children.
While children can be added as custom fields, just as a spouse can, the fundamental difference is that a contact can only have one spouse but can have multiple children. So, how many children fields do we need to create? Two? Three? What if Octomom becomes a customer? Will we need eight fields, one for each of her eight children? Yet, those fields will be empty for most (if not all) of the other contacts?
This is where a custom record comes into play. It is a new table that can be associated with an existing table, for instance, the contact table, and it can have one or more records related to the parent record, which is the contact record in our example.
To put it differently, custom fields are based...
