I have a checkbox lookup list for countries and a checkbox lookup list for locations in those countries.
Countries - (Lookup List 1)
Locations - (Lookup List 2)
Currently when I tick one of the countries (e.g. Austria), that country's locations will appear in Lookup List 2.
Is there a way to combine these two lookup lists into one cascading list so that when a country is selected, the locations appear in the same list like shown below?
Any help would be appreciated. Thanks.
Hi Sian Richardson,
You can use a Calculated Value inside a Repeating section, where the Calculated Value has the formula to get the Locations of the Countries.
Along with the Calculated Value, you can have Yes/No field in corresondense to select the location option.