I'm using a drop down list (country) to select multiple values in a multi-select lookup field (area codes).
This works good.
I can select united states in the drop down list and all area codes in the multi-select list get selected.
Trouble is there are hundreds of area codes added and they are all added in a random order. Is there some way to reorder the selections in the multi-select field?
Here is my code:
for each state in Add_by_State {
if (state = "All of United States") {
for each area in Region [Country.Name = "United States"] sort by State_Prov desc
{
Region.select(area.ID);
}
}
}
Nptice i am even sorting the fetch record but it seems the script still selects values in the multi-select at random.
Heres what i get: