Linking Records through Relationships, Querying with Relationships, and How to Delete a Relationship

This article walks through the steps to link contact records in your database together through relationships. This is different than trackinghousehold relationships– some examples include the tracking of employees at a corporation, or linking the owner of a business to their business.

Also covered is how toqueryby relationships (example: You can pull up a corporation, and all of the employees who work at the corporation into the same search query.)

In 2016 there were some major updates to the relationship module:

-You can now create your own relationship types that are different than the list of system defaults

-You can set a date range on a relationship (ex: this person worked at the company for this long)

-The steps to delete a relationship have also changed slightly

Steps

Navigate to your Contacts list (Voter/Donor). Search for and open the record you want to create a relationship for. I used the CargillCompany in this example.

Navigate to the Relation tab. Here you can view/modify the current relationships for this record. Click [+ New] to begin creating a new one.

Searchfor the contact you’re adding a relationship for, and click [Select]. *If the contact doesn’t exist you’ll need to create a new one. In this example I searched for myself ‘Joel Kristenson’ which was already in the database.

Select the relationship type from the drop-down if it exists. You can now click the [+] button to create your own relationship types if you need to. You can also record a note, and a date for the relationship.

Click [Save] once you’re finished. In my example I select the relationship type of employee, recorded a start date, and a simple note.

Here’s my finished example list of relationships in the Cargill Co. record card.

If you ever need to delete or modify relationships you’ll start by clicking on the bluerelationship ‘ID’ hyperlink. In my example I clicked on ID #4 for Elizabeth Albrecht.

Click the red [X] at the top of the popup screen to delete the relationship. You can also modify the data and save again if that’s your intent. In this example I deleted the relationship.

Click [OK] when prompted, if you wish to proceed.

Here’s my finished example after the relationship was purged.

The next steps show how to query by relationships.

Navigate to your Contacts (Voters/Donors) list.

Query for your contact, in my example I used Cargill again.

Click on the [+ Include Other] button on the Search Tool Strip.

Below are descriptions for the different options you have in this area.

Include Other Contacts Options

-Include other contacts in household.

oIf you’ve previously runhouseholding, you can use this option to pull up just the people who are part of the contact’s household.

-Include other contacts with same home address.

oThis is a good option if you haven’t yet householded your database, more typical for large voter databases.

For the purpose of this article, you’ll skip the first two options, and just check the 3rd box for ‘Include contacts connected through relationship records’.

You’ll notice that by default all the relationship types are checked, which isn’t a bad option if you want to pull up any record that is linked to the original record you searched by. For this example I cleared all check boxes using the sweeper brush button, and just checked the box for Employee [of Employer]. Click [OK] once you’ve made your selection. You’ll still need to click [Search] on the following screen to update the list of records in the grid.

Click [Search] to refresh your query. I was returned with a total record count of 6 (1 corporation, and 5 ‘linked’ employee records).

Note:To view a list of all your relationships and further analyze them you can view the Relationships list under the Application Menu. In my example I had 328.

TIP:A little trick to quickly get a list of other records that share the same home address as the record you’ve searched for in your list is to simply right-click on the record which will bring up a context menu with a few options, one of which is to list all other contacts that live at that address. Here’s an example (3 images) for Christopher Alden:

Img 1 of 3 – pull up a contact into your list

Img 2 of 3 – right-click and select to list all other contacts at that same address

Img 3 of 3 – all contacts at that address will populate in the grid, in this ex it was a total of 5 people

The related resources below link to a variety of other videos and articles related to this topic.