AnsweredAssumed Answered

Make your spouse linkable to their profile:  Part 2

Question asked by FM_Rookie on Dec 9, 2011
Latest reply on Dec 9, 2011 by philmodjunk


Make your spouse linkable to their profile:  Part 2


This is related to a previous question: Make your spouse linkable to their profile

It has been suggested that I start a new thread, so here is the question (there have been a few responses to my questiion on the old thread I will post here.

posted December 5, 2011 by FM_Rookie

How do you also automatically have the Spouse you just connected to the Contact also be connected with the Contact (as their Spouse) when you are viewing the Spouses profile as Contact? (I'm sorry if that's confusing)  I don't want to have to go to the Spouse & do the same for them.


posted December 5, 2011 by Mark Gores

If you have the contactID for each contact, then added a spouseID field to your contact table, you could relate a second TO of contacts called "Spouse"

Contacts::contactID = Spouses::SpouseID

Then set up a script so when you click the button to put Zoie"s ID in John's spouseID field, it also puts John's ID in Zoie's spouseID field.

Or you could set something like this up to trigger "On Modify" for the spouse ID field.

Freeze Window

Set Variable $contact = contacts::contactID

Set Variable $spouse = contacts::spouseID

perform find (contacts::contactID = $spouse)

Set Field spouseID; $contact

perform find (contacts::contactID = $contactID)

Show All Records

Refresh window

posted December 5, 2011 by PhilModJunk

Note: another option that allows you to link more than just two individuals to the same contact record is to use a join table--which then permits linking any number of people to the same contact record (all memembers of one family and living at the same residence, all employees of the same company....)

Current Response/Question to PhilModJunk

This was my orignal idea, but I couldn't figure out how to make the people I linked to have the original person in their portal when it was accessed.  In other words, if I associated Person1 with Person2 in LayoutA:PortalA, how do I set it up so that when I look at Person2 in LayoutA, Person2 appears in PortalA?  Because the portal is set up to show Person2's ID as the spouse, not Person1's.  (if this is confusing, I can upload a screenshot)

Thanks! And thanks others for your insight.  I just need to decide which approach will work best for us after I understand them all.