Table is Client
IDField is ClientID
Field is LastName
Layout is ClientLayout (Form)
A simple dropdown list showing LastName to go to the correct record.
I see discussions on this topic that are pages long, please....
Thank you for your post!
It looks like you'd need some combination of Value List based off of a Table with a Go To Related Record and a Script Trigger.
I'm going to move this thread from the FileMaker Community Feedback Space (which is specifically for input on the Community itself) to the Discussions Space where you should receive more views and potentially more feedback on this topic!
Those discussions are pages long for a reason. Much depends on your design and on exactly how you want to Go To a record--especially how you display the record once you go to it.
Not all those details are present in your post.
Resolved, thank you.
This discussion by Chris Cullen was very useful and solved the issue
Just remember to add: “ Enter Browse Mode “ at the end or the script will hang..
To answer your question: to choose records with a dropdown without changing data you need to create a new field - call it "ClientChooser" or something like that. When creating the field, click the options button (bottom right of the Manage Database dialog window) or double click the field to edit it's options. Click the storage tab. Click the "Use global storage" option.
Then place this field on your layout as the chooser field. Set it up as a dropdown list - getting its value from the ClientID field. On you field set script trigger to run the script "OnObjectModify".
The script should now be:
Enter Find Mode [ ]
Set Field [clients::clientID ; clients::ClientChooser ]
Retrieving data ...