Can you change option value based on a condition?

alex6789

Is it possible to do the following?

Lets say there are two dropdown options which I will call A and B. Based on the user selection in dropdown A, the options adjust for dropdown B. For example, dropdown A has 2 options: vehicle and colour. User selects vehicle for dropdown A. Now dropdown B has options: one, two, three, four. If user selects colour instead in dropdown A, for dropdown B we want it to show options one and two but hide three and four

mohana_cse06

I don't think we can change Option values dynamically.
You can use the Code field with TableRelation for different tables/pages like No. field based on the Type field.

mohana_cse06

I don't think we can change Option values dynamically.
You can use the Code field with TableRelation for different tables/pages like No. field based on the Type field.

bbrown

Consider using 2 different option text boxes for dropdown B. Hide\show based on the selection in dropdown A. Set the appropriate OptionString for each.