Hi,
I have two tables;
In table one i have ; i. country as a dropdown element and also have location as a fields element, Meaning the user select the country and enter the location where they resides.
In another table i am using a cascadingdropdown element, where you select a country and all locations linked to it show in the cascadingdropdown. Now the problem i have is that when say a location was entered more than once in the first table, it is repeating in the dropdown, how do i validate it to only show one location if it is repeating. Is there a code to restrict the repetition of the location?
Thanks.
I have two tables;
In table one i have ; i. country as a dropdown element and also have location as a fields element, Meaning the user select the country and enter the location where they resides.
In another table i am using a cascadingdropdown element, where you select a country and all locations linked to it show in the cascadingdropdown. Now the problem i have is that when say a location was entered more than once in the first table, it is repeating in the dropdown, how do i validate it to only show one location if it is repeating. Is there a code to restrict the repetition of the location?
Thanks.