1 Reply Latest reply on Feb 19, 2014 1:45 PM by philmodjunk

    Simple Find record navigate to layout script

    kentanderson

      Title

      Simple Find record navigate to layout script

      Post

           Can you give me an example of a script to find record based on a entered field and navigate to a different layout?  I was thinking of a field with data already in it, and you could click on the filed and navigate to a different layout using that field data.

           My field for example would be Job Number, and i want to go to layout #6, and find record based on the job number i clicked

           Thank You

        • 1. Re: Simple Find record navigate to layout script
          philmodjunk

               But is the current layout and "layout #6" based on the same table occurrence or different table occurrences? What is selected in "Show Records From" in Layout Setup in the two layouts?

               If they are based on the same table occurrence, no find is needed. If they are based on different table occurrences:

               Set Variable [$JobNumb ; value: FirstLayoutTable::JobNumber ]
               Go to Layout ["Layout #6" (LayoutSixTable) ]
               Enter Find Mode [] ---> clear the pause check box
               Set Field [ LayoutSixTable::JobNumber ; $JobNumb ]
               Set Error Capture [on]
               Perform Find []