Then you can have a auto calculated value in that field. Set this up in field
1 of 1 people found this helpful
I suggest you search this forum for "Conditional Value List" and take a look at the many posts. I think you'll find your solution among the search results. There are also some tutorial videos on YouTube if you prefer to consume the info that way.
You may find this helpful as well (thanks to Phil): Adventures in FileMaking #1--conditional value lists