AnsweredAssumed Answered

Scripted Find Problems

Question asked by bokenrosie on Apr 23, 2014
Latest reply on Apr 24, 2014 by philmodjunk


Scripted Find Problems


     I used the information provided in


     I have a a table for clients and another table for related contacts.  I'm looking to create a search method that will search a single box for a match in either table and return the results as client name, client city, contact last name, contact first name.

     When a user selects one of the rows in the results it will write that data to appropriate fields in a different layout.

     I started with New Layout

     I based the layout on clients (but they are related via a relationship to contacts)

     I added one field gName which is a global field name (was I supposed to relate that to something?)

     I then typed in the steps in the perform find 

Go To Layout [Select a layout based on table being searched]
Enter Find Mode [] ---> clear the pause check box
Set Field [YourTable::YourField ; Globals::gField]
Set Error Capture [on] ----> Keeps error dialog from interrupting script when no records are found
Perform Find []
If [Not Get ( FoundCount ) // no records were found ]
    Show Custom Dialog ["No records were found by this search."]
End IF

When I run the script nothing seems to happen.