Hi,
I have a dropdown box listing Agents from the Agent table. The user selects one from the list and the rest of the Agent's information automatically populates the form. The dropdown box lists the Agent's last name, first name, and title. So far, so good.
Problem is, right now the dropdown list that appears in the dropdown is sorting by the Agent's unique identifier, the key field in the Agent table. Not very user friendly, obviously, when they have to scroll through 500 agents to find the one they want.
My question is, how do I get the dropdown list to sort by the Agent last name?
I thought if I sorted the Agent table by last name, that would do it. But apparently that didn't work (I might have done something wrong, though).
Thanks for your time and help!
Blaine
I have a dropdown box listing Agents from the Agent table. The user selects one from the list and the rest of the Agent's information automatically populates the form. The dropdown box lists the Agent's last name, first name, and title. So far, so good.
Problem is, right now the dropdown list that appears in the dropdown is sorting by the Agent's unique identifier, the key field in the Agent table. Not very user friendly, obviously, when they have to scroll through 500 agents to find the one they want.
My question is, how do I get the dropdown list to sort by the Agent last name?
I thought if I sorted the Agent table by last name, that would do it. But apparently that didn't work (I might have done something wrong, though).
Thanks for your time and help!
Blaine