Permanently sort a list from a to z

[Cupcake]

I created a table that contains a list of roles.

When I created the table and added the values, I added them in alphabetical order but when you go to the form and click the magnifying glass the list is not sorted correctly.

How can I resolve this problem globally?

Can someone answer why is this happening, I've never had this issue reported before?

This is the table                                                                                                                                                                                   This is the Form in the portal

                 

Thanks,

Karen

[shloke04]

Hi,

Did you got a chance to Test the Solution provided for your query.

If your query is Resolved, Please mark the answer as correct so that the thread can be removed from the Unanswered list.

Regards,

Shloke

[Cupcake]

Good morning Shloke,

        I didn't get a chance to check the solution. I've been busy working on another major initiative.

Once I do I will not forget to come back and mark this as the correct answer.

Thanks,

Karen

[shloke04]

Hi,

Did you got a chance to Test the Solution provided for your query.If your query is Resolved would you mind marking the answer as correct and close the thread.

Regards,

Shloke

[Cupcake]

Actually no I did not. I am working on so many different projects that I had to begin to prioritize and this was not at the top of the list because the customer can actually sort it themselves. So when things calm down then yes I will get back to this.

I will definitely mark this a the correct answer if the solution works. I won't forget.

Thanks for the reminder.

Karen