Drop down question
I put a dropdown in the upper left hand corner, hoping to use it to navigate to other artists' records. When I click on one of the choices, nothing happens. Clues?
It would be good to understand the relationships involved. This is almost certainly the problem.
Here are the relationships.
Is "allow record creation enabled from Artist to Album?
At the moment when you change the Artist ID, you're just changing the _pk_ArtistID in that table.
What I'd do is create a new global field in the Artist table called g_SearchArtist. Which would replace the drop down selection you currently have.
Then create an OnObjectModify script trigger to perform a search of the Artist PK to the value in g_SearchArtist, when the selection is changed in the drop down.
Here's a thread with examples of scripted finds where the user selects or enters data in a global field before performing the script: Scripted Find Examples
Retrieving data ...