Brady, This can easily be achieved with Conditional Drop down fields.
https://help.quickbase.com/user-assistance/conditional_dropdowns.htmlYou have a simple case so I will describe a simple setup.
Make a new table called Work Choices with all your drop down choices. The table will have two fields. The first will be the Type which in your use case can be a simple Multiple choice required field with the two choices of
Service Call
Contract Work
The second called Work Category will hold your 6 choices
Then make a relationship where 1 Work Choices has Many Work Orders (or whatever your main table is called). Look up the Work Category down to Work Orders and set the field property for the Proxy field for Related Work Type to be the Work Category lookup field.
Put the field Work CategoryType on the Work Order Form.
Then edit the field properties for Related Work Category to make it conditional on first selecting the Type to only show choices in Work Category which match.
If you already have a working app with lots of data that you do not want to disturb when you do this, then before you make the relationship you will need ot set the Key field of your Work Category Choices table to be the Work Category field. Then when you make the relationship, you will need to set your current, presumably multiple choice, field as the reference field for the relationship.
Post back if you get stuck anywhere.
