Reciprocal Linkage, part 3

[3 Jan 2018: demo updated to version 3.2 as per Jens Rasmussen’s comment below.]

[2 Nov 2017: demo updated to version 3.1 as per my exchange with Jonathan Mickelson in the comments section below.]

I thought after part 2 that this technique had been thoroughly discussed and dissected, but Geoff Gerhard of Creative Solutions writes to point out that, if the goal is to have as few moving parts as possible, the table occurrence (TO) count can be further reduced, from four to three…

…and he has provided a demo file which I am sharing with his permission.

Demo file:

On the main layout the Linked Documents portal, which was formerly attached to join_doc, is now pointing at a second instance of doc_doc, filtered like so:


Also, the Hide Object logic on the “make link” icon has been streamlined:


I asked Geoff about the above, and he replied, “I like the look/logic of a single test. I think the explanation that the hide condition applies to the portal’s instantiation of the current record PLUS any/all linked records clarifies the logic of this construction.”

Additional changes: the join_doc TO has been removed from the Relationships Graph, and the navigation logic on this button has been updated.


4 thoughts on “Reciprocal Linkage, part 3

  1. Jonathan Mickelson

    Love the series, and blog, as always!

    PLATFORM: FM16 Mac
    PROBLEM: I’m not getting the same behavior on the V3 file as the Ver 2 files.

    If I go to Document 1 and link it to all other documents, and then navigate to the other documents the link to Document 1 does not display on them. Whereas, on the earlier v2 versions the reciprocal links did display for the linked document as well as the original doc I linked from.

    Am I missing something?

  2. Jens Rasmussen

    Great update. But I experience an unwanted cascading delete! Deleting current record makes them all go away…

    1. Kevin Frank

      Thank you Jens. Demo file has been updated to v3.2 to remove the unwanted deletion dependency between doc and doc_doc.


Leave a Reply