This can be done, but why? Why not make it a related table so that you don't have to script a find to access this data?
If your drop down list is set up to format a global field, a script such as those found here: Scripted Find Examples
Will find the record or records matching the info entered or selected for your global field.
Thank you so much for responding.I should have asked the question differently. I might have done that the first time if I wasn't new to the program, but I didn't want to bother you with all the specific details of my little problem.I have the following script that works, but would like to replace the CASE command with a table:If [ List Parameters::Mobile Numbers ≠ "-" ]Set Error Capture [ On ]Set Field [ <Table Missing>; "" ]Set Variable [ $$MOBILENUMBER; Value:Case ( List Parameters::Mobile Numbers = "Fred" ; "8884532180" ; List Parameters:: Mobile Numbers = "Mike" ; "8886542323" ; List Parameters::Mobile Numbers = "Tom" ; "8887654323" ) ]Set Variable [ $$SCRIPT_TRIGGER; Value:"Off" ] End IfSend Mail [ Send via SMTP Server; To: $$MOBILENUMBER & "@txt.att.net"; Message: Residential Customers::Last Name & ", " & Residential Customers::First Names & ¶ &Residential Customers::Street Address & ¶ &
Residential Customers::City & " " & Residential Customers::Zip & ¶ &
Residential Customers::Phone & ¶ &
Residential Customers::Number of Systems & " Systems"; Name: "Douglas Mechanical, Inc."; Email Address: "firstname.lastname@example.org"; Reply-To Address: "email@example.com"; SMTP Server: "smtp.gmail.com"; Port: 465; Use SSL; Authentication Type: Plain Password; User Name: "firstname.lastname@example.org"; Password: "**********"My thinking is that if the names and numbers are in an easily viewable table, the numbers could be easily changed by others without changing the script. The table would be as follows:EMPLOYEES tableNAMES MOBILE NUMBERSFred 8884532180Mike 8886542323Tom 8887654323Any thoughts? And thank you for your time.Fred