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

 

Tables:

   Pens Table >>>> PenInk Table <<<<< Ink Table

  

Relationships:

   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…?

Outcomes