1 2 Previous Next 22 Replies Latest reply on Sep 2, 2015 9:28 AM by Paper_Queen

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


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

        1 2 Previous Next