Fields Repeating in a cascadingdropdown

[jigmode]

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.

 

[jigmode]

Is really need help with this issue, is there anyone out there to help. thanks

 

[cheesegrits]

Not baked in, no. It might be possible to do something with the options eval code, under the advanced tab, see if you can maintain an array of names you'vre seen, and return false for ones you have (which will remove them from the options).

-- hugh