Make Family Member profiles link to Current profile-FM11
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
Their are 3 Table Occurences (TO): (Those in CAPS are the table the layout is based on)
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.