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