We are setting up a General List to track the consumption of hardwares at different sites in the world.
There are two columns in this general list. One is Combination which can have three values (Region/Country/Site).
The next column is Combination_Name.
The idea is based on the value entered in the Combination column, the Combination_Name should show a relevant list of values. ex. If the users enter Region in the Combination column,then they can select either EMEA or APAC or AMERICAS in the Combination_Name. Same way, if they select Country in the Combination column, thenCombination_Name will have the list of countries from which users will select one.
Much appreciate if anybody provides some pointers on how this can be acheived.