I am creating a small table to track certain parts that are being replaced on certain pieces of equipment, and was wondering if there was a way to where if I select an item from a combo box in Field 2 (for example equipment), if the selection of a certain item can dictate the items available in the combo box for field 3. For Example:
If I select Crane 1 in the combo box in field 2, it will change the list in field 3's combo box to only the items associated with Crane 1.