The generic answer to your question, is that this is relatively easy.
- For your Type of Request field, use the second tab on the properties box and check the box that says “Refresh fields on keyword change” – this will refresh/recalculate the form whenever the user changes the value of the Type of Request field.
- For your Status field, use the second tab on the properties box and check the box that says “Refresh choices on document refresh”
- For the Status field, on the second tab, set the dropdown for Choices to “Use formula for choices” and set the formula to your requirements. Here’s an example:
@If( RequestType=”X”; “A” : “B” : “C”; RequestType=”Y”; “Red” : “Blue” : “Green”; “Uncaught exception” )
So, if Type of Request is X, the choices for Status will be A, B, C
if Type of Request is Y, the choices will be Red, Blue, Green
If you need more customization, then look at the third tab on the properties box for Type of Request and consider checking the box that says “Run Exiting/OnChange events after value change” – then use code in those events to do what you want.