Simple Member Example
Using Member Keys
- Set the Family Key to indicate which family the member belongs to.
- Use the Member Key so future imports can be linked to the correct member (such as sacraments or ministry information).
Primary and Foreign Keys
- Primary Key – Uniquely identifies a row. Once you use a primary key in a table, it should not display again in that file. Other files reference the primary key.
- Foreign Key – Establishes a link to another row in a different table. Foreign keys in a related table reference the primary key in a main table.
In the simple family and member examples, the FamKey field is the primary key in the FamilyBasicInfo.csv file. In the FamilyHomePhones.csv and MemberBasicInfo.csv files, FamKey is the foreign key.
After reviewing this section, if you don’t feel confident about how these apply to your file(s), contact PDS Support at 1-877-737-4457. Fees may apply.