If I have a drop down list with multiple values from a value list, is there a way to have a second field change depending on what the user chooses in the drop down list?
This is a very generic description; you may want to give more info to save people from speculating all over the place – e.g. is there a relationship involved? Do you want a conditional VL? – and is the fact that the field in question is formatted as a dropdown pertinent?
That being said: how about simply using an auto-enter calculation for the second field?
Yes, there are a couple of ways to do this. You can either use an OnObjectModify or OnObjectSave script trigger to change your second field based on the value being saved by the valuelist, or you can create a relationship to a table with your second valuelist and make the relationship based on the value selected from the first valuelist.
Could you give me an example of how I would implement either an OnObjectModify or OnObjectSave script trigger?
There are several ways to do this... here in one. Hope this helps.
Creating conditional Value Lists | FileMaker
Here's an example of using a script trigger.
Retrieving data ...