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

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

        1 2 Previous Next