I'm building an app for a youth camp, so there are children, parents, teachers, volunteers, staff members and others involved.
Is it best practice to use the contacts object only with multiple record types or a separate object for each type of person?
If I use a separate object for each, which type of relationship should I house in the Contacts object? Or do I just pick one and it doesn't matter?
#Data #Best Practices #Lookup Relationships #Fields & RelationshipsAjaypreet Singh Saini (Grantbook) 
Forum Ambassador
Hey @Tom Rawling, I agree with Andrew.
You should use the just contact with no separate record types for different relationships.
You can use either picklist field as Andrew mentioned above or you can create a custom relationship object that will be related to the Contact object so that you can store the relationships there.
This model is already utilized by Non-profit Success Pack (in the non-profit space) and here is the entity diagram to see the relationship between those 2 objects:
