I've tried every combination that comes to mind...must be missing something reeeeeeally basic.
Database: Inventory fountain pens and inks
Pens Table >>>> PenInk Table <<<<< Ink Table
Pens Table (Pk_InkID) >>> PenInk Table (fk_InkID)
Inks Table (Pk_PenID) >>> PenInk Table (fk_PenID)
Goal: From an Ink record, find all occurrences of that ink in the Pen+Ink layout
Action: Click the "Find ink in P+I records" button...
...then be whisked to the "Pen+Ink" layout, showing only records for that ink:
A scripted button is the best fit for the layout, but somehow, I just can’t get a script to do this. Hints, anyone…?