AnsweredAssumed Answered

Script? Search for field contents, then display in related layout

Question asked by Paper_Queen on Aug 31, 2015
Latest reply on Sep 2, 2015 by Paper_Queen

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

Screen Shot 2015-08-30 at 6.49.22 PM.png


...then be whisked to the "Pen+Ink" layout, showing only records for that ink:

Screen Shot 2015-08-30 at 6.43.31 PM.png


A scripted button is the best fit for the layout, but somehow, I just can’t get a script to do this. Hints, anyone…?