Globally adding relationship between two existing constituents
Hello, Everyone.
What is the best/easiest way to create a relationship between two existing constituents. Let's say we have a group of students and a group of parents. We want to add the relationships between the two groups respectively.
Thank you.
Comments
-
@Bernard Nemis To the best of my knowledge to do within RE it's one record at a time. I would use a query of the parent or students. Click to open each record (I would set default to open each record on relationship tab - just a short cut I frequently use.) and create a new individual relationship record to the appropriate person, adding the relationship/reciprocal. You then get pop-up to add relationship to the other record.
To do globally add you would be adding the same person to each record in the query. Not what you want.
It could be done by import - it might be worth the work but you'd have to take each ‘parent’ and somehow get the correct ‘student’ record id. Would be a challenge if there's no link to who should match with whom.
0 -
@Bernard Nemis
The easiest way to do this would be using Individual Relationship Import in RE database view.make sure you have automatically reciprocate relationship for your purpose.
You will just need to start from the parent or the child side. If you start from parent, you need the parent's Constituent ID or Constituent Import ID, and you will need the child's Constituent Import ID (cannot use COnstituent ID).
3 -
@Alex Wong
Thanks, Alex. I will check this out. I appreciate it.0 -
@JoAnn Strommen
Hello, JoAnn. Thanks for your feedback. I will have to go the Import route as we have a good amount of incoming freshmen (with potential two parent records each) to connect. We currently have ImportOmatic, but I wanted to see how other folks are doing it, and see if that's something we can do via regular BB import.1 -
@JoAnn Strommen
Hello, JoAnn. Thanks for your feedback. I will have to go the Import route as we have a good amount of incoming freshmen (with potential two parent records each) to connect. We currently have ImportOmatic, but I wanted to see how other folks are doing it, and see if that's something we can do via regular BB import.Having done this before, for a class of 500 students where each parent had their own record, I would absolutely use ImportOmatic. Especially if you will be importing a mix of new students to existing parents, and completely new families. RE's native import functionality doesn't allow you to manage potential duplicates or updates to information during the import process like IOM does.
Karen
1 -
@Karen Diener
Thank you, Karen! I appreciate your feedback.0 -
@Bernard Nemis Let me agree and add on to @Alex Wong's sage advice. If you go the import route, it is suggested that you use the import to create the import file to get the fields you need. It's a chore without question.
0 -
@Dariel Dixon
Thanks for affirming, Dariel. I will definitely go that route.1 -
@JoAnn Strommen
Hello, JoAnn. How do you change the default so that each record opens in the Relationship tab when you click on a record from Query?Thanks!
0 -
@Bernard Nemis In db view, on menu at top of window go to Tools > User Options > Records tab. In the top box for default tab instead of Bio 1 select Relationships.
Just a couple clicks to reverse when you're done with that task.I use this frequently when working on various tasks/data.
1 -
@JoAnn Strommen
Thanks, JoAnn! I appreciate it.0 -
@Alex Wong
Hello, Alex.Quick question, I saw an article in knowledgebase that all you need are the parent's ImportID and the Child's ImportID, Relationship, and Reciprocal as the basic fields to be able to import/create a relationship between the parent and the child (from the Parent's record). I was able to do this and saw the child relationship in the parent's record. However, when I go to the child's Relationship tab, there's no relationship to the parent. Am I missing something so that the relationship is added to both records? Come to think of it, do I need to create a new row and reverse the values for the ImportIDs and the Relationship/Reciprocal?
0 -
when you do the import, you must check the checkbox “Automateically reciprocate relationships" in order for both “parent” and “child” constituent to have the relationship record.
1 -
@Alex Wong
Ahhh. I missed that on your last post. Thank you very much!!!0
Categories
- All Categories
- Shannon parent
- shannon 2
- shannon 1
- 21 Advocacy DC Users Group
- 14 BBCRM PAG Discussions
- 89 High Education Program Advisory Group (HE PAG)
- 28 Luminate CRM DC Users Group
- 8 DC Luminate CRM Users Group
- Luminate PAG
- 5.9K Blackbaud Altru®
- 58 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 409 bbcon®
- 2.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- donorCentrics®
- 1.1K Blackbaud eTapestry®
- 2.8K Blackbaud Financial Edge NXT®
- 1.1K Blackbaud Grantmaking™
- 527 Education Management Solutions for Higher Education
- 1 JustGiving® from Blackbaud®
- 4.6K Education Management Solutions for K-12 Schools
- Blackbaud Luminate Online & Blackbaud TeamRaiser
- 16.4K Blackbaud Raiser's Edge NXT®
- 4.1K SKY Developer
- 547 ResearchPoint™
- 151 Blackbaud Tuition Management™
- 1 YourCause® from Blackbaud®
- 61 everydayhero
- 3 Campaign Ideas
- 58 General Discussion
- 115 Blackbaud ID
- 87 K-12 Blackbaud ID
- 6 Admin Console
- 949 Organizational Best Practices
- 353 The Tap (Just for Fun)
- 235 Blackbaud Community Feedback Forum
- 55 Admissions Event Management EAP
- 18 MobilePay Terminal + BBID Canada EAP
- 36 EAP for New Email Campaigns Experience in Blackbaud Luminate Online®
- 109 EAP for 360 Student Profile in Blackbaud Student Information System
- 41 EAP for Assessment Builder in Blackbaud Learning Management System™
- 9 Technical Preview for SKY API for Blackbaud CRM™ and Blackbaud Altru®
- 55 Community Advisory Group
- 46 Blackbaud Community Ideas
- 26 Blackbaud Community Challenges
- 7 Security Testing Forum
- 1.1K ARCHIVED FORUMS | Inactive and/or Completed EAPs
- 3 Blackbaud Staff Discussions
- 7.7K ARCHIVED FORUM CATEGORY [ID 304]
- 1 Blackbaud Partners Discussions
- 1 Blackbaud Giving Search™
- 35 EAP Student Assignment Details and Assignment Center
- 39 EAP Core - Roles and Tasks
- 59 Blackbaud Community All-Stars Discussions
- 20 Blackbaud Raiser's Edge NXT® Online Giving EAP
- Diocesan Blackbaud Raiser’s Edge NXT® User’s Group
- 2 Blackbaud Consultant’s Community
- 43 End of Term Grade Entry EAP
- 92 EAP for Query in Blackbaud Raiser's Edge NXT®
- 38 Standard Reports for Blackbaud Raiser's Edge NXT® EAP
- 12 Payments Assistant for Blackbaud Financial Edge NXT® EAP
- 6 Ask an All Star (Austen Brown)
- 8 Ask an All-Star Alex Wong (Blackbaud Raiser's Edge NXT®)
- 1 Ask an All-Star Alex Wong (Blackbaud Financial Edge NXT®)
- 6 Ask an All-Star (Christine Robertson)
- 21 Ask an Expert (Anthony Gallo)
- Blackbaud Francophone Group
- 22 Ask an Expert (David Springer)
- 4 Raiser's Edge NXT PowerUp Challenge #1 (Query)
- 6 Ask an All-Star Sunshine Reinken Watson and Carlene Johnson
- 4 Raiser's Edge NXT PowerUp Challenge: Events
- 14 Ask an All-Star (Elizabeth Johnson)
- 7 Ask an Expert (Stephen Churchill)
- 2025 ARCHIVED FORUM POSTS
- 322 ARCHIVED | Financial Edge® Tips and Tricks
- 164 ARCHIVED | Raiser's Edge® Blog
- 300 ARCHIVED | Raiser's Edge® Blog
- 441 ARCHIVED | Blackbaud Altru® Tips and Tricks
- 66 ARCHIVED | Blackbaud NetCommunity™ Blog
- 211 ARCHIVED | Blackbaud Target Analytics® Tips and Tricks
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- Luminate CRM DC Users Group
- 225 ARCHIVED | Blackbaud eTapestry® Tips and Tricks
- 1 Blackbaud eTapestry® Know How Blog
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
- 1 Blackbaud K-12 Education Solutions™ Blog
- 280 ARCHIVED | Mixed Community Announcements
- 3 ARCHIVED | Blackbaud Corporations™ & Blackbaud Foundations™ Hosting Status
- 1 npEngage
- 24 ARCHIVED | K-12 Announcements
- 15 ARCHIVED | FIMS Host*Net Hosting Status
- 23 ARCHIVED | Blackbaud Outcomes & Online Applications (IGAM) Hosting Status
- 22 ARCHIVED | Blackbaud DonorCentral Hosting Status
- 14 ARCHIVED | Blackbaud Grantmaking™ UK Hosting Status
- 117 ARCHIVED | Blackbaud CRM™ and Blackbaud Internet Solutions™ Announcements
- 50 Blackbaud NetCommunity™ Blog
- 169 ARCHIVED | Blackbaud Grantmaking™ Tips and Tricks
- Advocacy DC Users Group
- 718 Community News
- Blackbaud Altru® Hosting Status
- 104 ARCHIVED | Member Spotlight
- 145 ARCHIVED | Hosting Blog
- 149 JustGiving® from Blackbaud® Blog
- 97 ARCHIVED | bbcon® Blogs
- 19 ARCHIVED | Blackbaud Luminate CRM™ Announcements
- 161 Luminate Advocacy News
- 187 Organizational Best Practices Blog
- 67 everydayhero Blog
- 52 Blackbaud SKY® Reporting Announcements
- 17 ARCHIVED | Blackbaud SKY® Reporting for K-12 Announcements
- 3 Luminate Online Product Advisory Group (LO PAG)
- 81 ARCHIVED | JustGiving® from Blackbaud® Tips and Tricks
- 1 ARCHIVED | K-12 Conference Blog
- Blackbaud Church Management™ Announcements
- ARCHIVED | Blackbaud Award Management™ and Blackbaud Stewardship Management™ Announcements
- 1 Blackbaud Peer-to-Peer Fundraising™, Powered by JustGiving® Blogs
- 39 Tips, Tricks, and Timesavers!
- 56 Blackbaud Church Management™ Resources
- 154 Blackbaud Church Management™ Announcements
- 1 ARCHIVED | Blackbaud Church Management™ Tips and Tricks
- 11 ARCHIVED | Blackbaud Higher Education Solutions™ Announcements
- 7 ARCHIVED | Blackbaud Guided Fundraising™ Blog
- 2 Blackbaud Fundraiser Performance Management™ Blog
- 9 Foundations Events and Content
- 14 ARCHIVED | Blog Posts
- 2 ARCHIVED | Blackbaud FIMS™ Announcement and Tips
- 59 Blackbaud Partner Announcements
- 10 ARCHIVED | Blackbaud Impact Edge™ EAP Blogs
- 1 Community Help Blogs
- Diocesan Blackbaud Raiser’s Edge NXT® Users' Group
- Blackbaud Consultant’s Community
- Blackbaud Francophone Group
- 1 BLOG ARCHIVE CATEGORY
- Blackbaud Community™ Discussions
- 8.3K Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions
- 5.7K Jobs Board