Trail Blazer Knowledge Base

 

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

Knowledge Base







User:

Password:



Article ID: KB274
Keyword Name: Relationship, Employee, Business Owner, Linking Contacts, Delete Relationship
Created: September 19, 2016
Viewed: 18348

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




Click Here to view this article as a PDF.





Author: Kristenson, Joel

Last Updated: 2016-09-19






Overview


This article walks through the steps to link contact records in your database together through relationships.  This is different than tracking household 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 to query by 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 Cargill Company 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.



Search for 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 blue relationship ‘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.

o If you’ve previously run householding, 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.

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

- Include contacts connected through relationship records.

o Choose from specific or multiple relationship types to query by i.e. Employer, Employee, Business Owner, Cousin, Colleague, All Relationship Types, etc.


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 MenuIn 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.














Related Resources


Article: Delete a Relationship

Article: How to Split a Single Contact Record into a Duplicate Contact Record for Householding a Couple

Article: Splitting ‘Couples’ into Separate Records En Masse using the Built-In Utility

Article: Managing Households – Creating, Deleting, and Re-creating

Article: Automatically Conform Addresses

Article: Address Management

Article: Why won’t some of my records merge?

Article: Address Normalization (unlimited addresses per person)

Article: Save and Load a Search Query as a (Dynamic) Search Favorite

Article: SQL Wildcards

Article: Advanced Queries – the SQL Tab

Article: Delete Saved Search Queries

Video: Households – What To Do B4 Householding!!

Video: Households – Delete and Recreate

Video: How to Manage Duplicates

Video: Households – Drag n Drop

Video: Households – Combine More Than 5 Members

Video: Video Playlist on Queries





Trail Blazer Live Support


http://www.somebodysattic.org/images/phone%20icon_lower%20rez.jpg  Phone:  1-866-909-8700

http://sisyphus-js.herokuapp.com/assets/email_icon-0f32f4da45c2822cbb02fb36f9b9429e.png   Email:  support@trailblz.com

   Facebook: https://www.facebook.com/pages/Trail-Blazer-Software/64872951180

   Twitter: https://twitter.com/trailblazersoft



* As a policy we require that you have taken our intro training class before calling or emailing our live support team.


Click here to view our calendar for upcoming classes and events.  Feel free to sign up other members on your team for the same training.


* After registering you’ll receive a confirmation email with the instructions for how to log into the GoToMeeting session where we host our live interactive trainings.


* This service is included in your contract.



 

Are you ready to learn more? Contact Us