I need to create two fields, both set as pop-up lists, where the options in the second field are determined
by the selection made in the first field.
For example, the first field would contain "Colors, Foods, Animals" as choices. If "Colors" is chosen,
then the second field would contain "Red, Blue, Orange" as choices, but if "Animals" was chosen in the
first field then the second field choices would automatically set to "Dog, Cat, Elephant."
Is this possible? I heard that it could be done by a nested "IF" calculation, but I'm sort of at a
loss as to how to get started............