I am at a loss here. I have successfully implemented philmodjunk's solution, thank you Phil, in Adventure2EVS to sorting a drop down list. Sort of. One out of the three drop down lists successfully sorts the content and works as advertised, but the other two drop down lists don't drop down.
All three reference tables are configured identically, as are the dropdown lists.
Any insight would be appreciated.
The solution was created on a Mac Powerbook Pro OS 10.14 using FMP 126.96.36.199 and is running on a Windows Server 2016 with FMServer 17