2 Replies Latest reply on Sep 19, 2011 11:13 AM by Syfy

    Find Record

    Syfy

      Title

      Find Record

      Post

      Anybody can help please..

      Find record script . StudentIDNumber in edit box to be find in relation table and display find data in StudentFirstName, LastName, etc. But I find it difficult How to create a script when StudentIDNumber inputted in edit box were not found in another table, prompt a message and focus the cursor back to StudentIDNumber. Thank you.

       

       

       

      editbox.png

        • 1. Re: Find Record
          philmodjunk

          Set Variable [$StudentID ; value: YourTable::_fkStudentIDNumber]
          Go to Layout [//select layout of "another table"]
          enter find mode[] // clear the pause check box
          Set Field [OtherTable::StudentIDNumber ; $StudentID]
          Set Error Capture [on] //keeps dialog box from interrupting script if no records are found
          Perform Find[]
          If [Get ( FoundCount ) = 0 ]
             Go to layout [Original layout]
             Go To Field [YourTable::_fkStudentIDnumber]
             Show Custom Dialog ["No such student record was found..."]
          End If

          • 2. Re: Find Record
            Syfy

            Thank you very much PhilModJunk for unselfish answer to my query... I really appreaciate and God Speed.