hangman said, "But the other fields like cooking instructions, ingredients etc are not changing records with the corresponding recipe title."
Hi hangman, you are missing a scripted FIND.
You will allow the user to select from the dropdown (which is attached to a global field). Then they would click a button next to the dropdown (or if you have script triggers, you can trigger the script) which will then find the recipe(s). It might look something like this:
# user selects value from dropdown which inserts the value in the global then click button or trigger this script ...
Enter Find Mode [ uncheck pause ]
Set Field [ yourTable::yourTitle ; global field ]
Set Error Capture [ On ]
Perform Find [ ]
If [ Get ( LastError ) // no records found ... unlikely since the value list is based upon Title values which exist ]
Show Custom Dialog [ "No records found." ]
... do whatever if no records found
... record(s) found ... it would display the record (or records) with this title right where you are since you are performing the find in the Recipes table
Many thanks for your reply and help.
I'll try out your script solution and let you know how i get on.!
I've been trying for a few nights now and I'm struggling to get this script to work.
below is the script, and i've set the trigger on the global storage field "search_title". I've specified the script to run on "OnObjectModify" but it doesn't seem to work on any of the events?
Can anyone help please? many thanks
Enter Find Mode  //pause unchecked
Set Field [Recipes converted::Search_Title] //search_title is the global storage field
Set Error Capture [On]
Perform Find 
If [ Get ( LastError )
Show Custom Dialog ["Drop Down Menu Error"; "No records found"]
Set Field is incomplete. It should have two items (parameters) separated by a semi colon.
When Setting up Set Field, there are two Specify buttons that must be clicked. To get Set Field [Table::Field ; Expression], add set field to your script and click the first button (specify target field). Select Table::Field from the list of fields. Click OK. Now click the lower specify button (calculated result) and create the expression to the right of the semicolon (;). Do not try to type in the semicolon.
Many thanks for the help that did the trick!
You were right, I was trying to type in the semicolon to try and copy the script exactly as LaRetta had kindly showed me, but couldn't seem to do it :-)
Now i've got this script working I guess I can adapt it for use in other databases when i want records displayed from a drop down list?
But of course. This is a frequently used tool in FileMaker.