I have an app to add clients to the calendar view. Thanks to all the help on this site, all is going well. I’m stuck on a fairly simple step though. When I click the drop down next to client ID:
it brings up a list of all clients in the Clients table. How do I firstly, sort this list in alphabetical order and secondly show only the current clients? I have managed to grey the past clients but cannot seem to remove them from the drop down.
There is an enum column in the client table for current or past. The client table links to the client dives table where one client can have many dives and it is this client dives table that I still need to show all details of past clients (in a different view) but in this form, only bring up present clients on the list.