Desk. Version 2020 R1.2.
Query: select name,area.areaid,said from area Left Join staffArea on area.areaid = staffarea.areaid And staffid = ‘key_goes_here’ order by name
This works fine in Valentina Studio. In Xojo it gets a syntax error.
What I’m trying to do is show a list of “areas.” A person can be assigned to one or more of them. The list would appear in a listbox with checkboxes in column 0. Users would be able to assign (or unassign) areas to a person by clicking the checkbox.