Restricting selections in enum columns? I ha...

[Dialect_Junk]

Restricting selections in enum columns?

I have 2 enum columns:

Column #1: “Asset Status” with options for “In Service” and “Out Of Service”. Column #2: “Work Order Status” with options for “Started” and “Completed.”

If “Out Of Service” is selected in column 1, I want to restrict column 2’s option to “Started,” only.

Is this possible with enum column? Any other strategies?

Thanks, all.