Populate options in choice columns

[human_hide]

Hello,

I have two choice columns, Column A, which has the details of the Industry and Column B which contains the Sectors. Is there any way where I can populate the options I see in Column B based on the option I select in Column A.

I have already tried setting it up using a look-up functionality which is not helping. Can this be done by writing a rule in the form?

Thank you in advance!

Ronnie

[andrewg · Accepted solution]

You could setup a Calculated Value control on the form, then in the formula use the Runtime function of lookup. Use the lookup as lookup("List name", "Column A (as text)", "Insert reference of named control here, which is probably Column A", "Column B (the column to show on filter)")

So when a selection is made on column A, then the corresponding value in column B is shown. 

Ok, and if the control displaying Column A on the form is a Lookup control, then in the formula above needs a slight change by including a parselookup. This little function remove the 3;# in  3;#columnAvalue so it can be used by the lookup function.

lookup("Industry List", "Column A", parselookup("Column A"), "Column B")