Variable Value List
I am trying to create a field whose value list is based upon the data that is entered into a previous field. For example, Field1 is the Main Category Field, which has a value list of 5 categories. The end-user would choose one of these 5 categories for this field. The next field, Sub Category Field, would then have a pull-down value list, based upon the value entered in the Main Category Field.
Anyone know how to do this?