Are you sure you want the denomination field to be a drop down. Seems like there's really no choice the user can make, each Country only has one denomination, or am I missing something?
You could use a calculation field for the denomination field.
the calc would look something like:
tableName::CountryField = "US" ; "Dollars" ;
tableName::CountryField = "France" ; "Euros" ;
Changing the Country field will automatically set the denomination field.
If this is a coin collection, each country has its own series of unique coins. The US has penny, nickel, dime, quarter, half-dollar, dollar.
Maybe a child table could hold the currencies where the parent table is the country. Maybe also a list() could be used to hold the currencies, and then these list() could be inserted into the case function.
Thanks for the suggestions. To be clear:
There is a LONG list of countries (a couple of hundred members), and each country may have several denominations of coin as pointed out. The US today has penny, nickel, dime, quarter, 1/2 dollar, dollar. And don't forget that is just today; there used to be 1/2 cent, 3 cent, disme, 20 cent, etc.
So hard coding a list in a script doesn't sound maintainable. If I had a parent table of all countries driving one drop down and used the country name or some other key to look up into a related table of denominations I could maintain it. The question is, what is the best technique to have the child table populate a dropdown list based on the selected value of the parent "Country" list?
Perhaps this article on creating conditional value lists may solve it for you: