AnsweredAssumed Answered

Make Family Member profiles link to Current profile-FM11

Question asked by FM_Rookie on Apr 14, 2012
Latest reply on Apr 16, 2012 by philmodjunk

Title

Make Family Member profiles link to Current profile-FM11

Post

I've been working on this TOO LONG, & I still can't figure it out.  The screenshot below shows what I want, but I can't get it to work (ignore the data there that makes it seem that it works... it doesn't).

Here's what I have

Contacts::__kp_ContactID

FamilyJoinTable::__kp_JoinTableID
FamilyJoinTable::_kf_ContactID
FamilyJoinTable::FamilyID

Their are 3 Table Occurences (TO): (Those in CAPS are the table the layout is based on)
CONTACTS
contacts_FAMILYJOINTABLE
contacts_familyjointable_FAMILYMEMBER (this is based on table "Contacts")

The TOs are joined
Contacts::__kp_ContactID = FamilyJoinTable::_kf_ContactID = contacts_familyjointable_FAMILYMEMBER::__kp_ContactID (because this is actually the "Contacts" table)

OK... looking at the portal below, how do I use the drop-down list (value list works fine) to populate AND join them?  When I hit "go" (which brings them to the related record) it doesn't work because I can get FamilyJoinTable::FamilyID to produce an ID number and then populate in this related record.

Should I produce the FamilyID in the "Contacts" table??  If so how?  I'm not good at writing (or even understanding scripts).  Most of mine have been copied from people who know what they're doing.

Thanks!

pic.png

Outcomes