Globally adding relationship between two existing constituents

Options

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

  • JoAnn Strommen
    JoAnn Strommen ✭✭✭✭✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic

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

  • Alex Wong
    Alex Wong ✭✭✭✭✭
    Ninth Anniversary Facilitator 4 Name Dropper Photogenic

    @Bernard Nemis
    The easiest way to do this would be using Individual Relationship Import in RE database view.

    6349f7cd5236bd5d66aa76eca64753bf-huge-im

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

  • @Alex Wong
    Thanks, Alex. I will check this out. I appreciate it.

  • @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.

  • Karen Diener 2
    Karen Diener 2 ✭✭✭✭✭
    Ancient Membership Facilitator 3 Name Dropper Photogenic

    @Bernard Nemis:

    @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

  • @Karen Diener
    Thank you, Karen! I appreciate your feedback.

  • Dariel Dixon 2
    Dariel Dixon 2 ✭✭✭✭✭
    Seventh Anniversary Facilitator 4 Name Dropper Photogenic

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

  • @Dariel Dixon
    Thanks for affirming, Dariel. I will definitely go that route.

  • @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!

  • JoAnn Strommen
    JoAnn Strommen ✭✭✭✭✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic

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

  • @JoAnn Strommen
    Thanks, JoAnn! I appreciate it.

  • @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?

  • Alex Wong
    Alex Wong ✭✭✭✭✭
    Ninth Anniversary Facilitator 4 Name Dropper Photogenic

    @Bernard Nemis

    6349f7cd5236bd5d66aa76eca64753bf-huge-im

    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.

  • @Alex Wong
    Ahhh. I missed that on your last post. Thank you very much!!!

Categories