How do I do an Order by lookup display?

vilhenamix · Post by **vilhenamix** » Sat May 18, 2019 8:45 am

I have a table enrollment, which searches the student through lookup,
in the listing of the registration ORDER BY orders taking ID (link field), so the alphabetical order is all wrong.

How do I sort by student name (display field) ???

mobhar · Post by **mobhar** » Sun May 19, 2019 6:06 pm

Just create a Database View based on that "enrollment" table that ORDER BY student name, and then simply use that Database View as your Lookup Table.

vilhenamix · Post by **vilhenamix** » Thu May 30, 2019 12:11 am

thanks for the tip, everything went well
thank you!