AnsweredAssumed Answered

Auto Delete Find Field

Question asked by anicolais on Oct 21, 2009
Latest reply on Oct 21, 2009 by philmodjunk


Auto Delete Find Field


The Company_Seacrch_Company field is a field on my layout that the user enters a company name into and clicks the find button next to it which executes the script below. How would I make this script also go back the the orignial record and delete the text in the field Comapny_Search_Company automatically while still executing the search afterwords. The problem I am having is that the original record that the user enters the info into retains this information which makes it confusing for the next user that decides to do a search from this record. (ex. generally the first record in my database has abotu 10 company names in the Company_Search_Company field becase the user doesnt understand they have to delete the field before trying to search for a different company.)


Set Variable [$ID; Value:Company::Company_Search_Company]

Enter Find Mode []

Set Field [Company::Company;;Company_Name; $ID]

Perform Find[]

If[Get(FoundCount) = 0]

Go to Layout [original layout]

Show all Records

End If