MicrosoftThe new editor is eyecandy only. It doesn't support subqueries. For example, when switching this SQL query "SELECT * FROM (SELECT PrimaryKeyField, Field1, Field2 FROM Table) AS ReqTable" in design mode, you will see the subquery "ReqTable" but you won't see the fields in it (PrimaryKeyField, Field1, Field2). So it's impossible to create a relation on "ReqTable.PrimaryKeyField" with another table from there... Very disappointing and useless for me...
According to https://www.isladogs.co.uk/monaco-sql-editor/index.html#KI, (scroll down to item s), this bug occurs only when there is a line break before the "FROM" in the subquery. If you remove the line break, you should be able to see the subquery fields in design view. Hopefully they'll fix the bug, but at least there's a workaround.
This bug has now been fixed in both Beta and Current Channels (along with many of the other bugs reported over the past couple of months)
awesome website
I know that because I did discover the bug and communicate with isladogs.co.uk to tell them. They told me that the bug seams to be resolve in the beta release of Microsoft Access. So we just need to wait until the beta version moves into official version and we will get this bug fixed. Thanks to Colin from isladogs.co.uk for his support!
The provided link is very helpful. Also removing the line break fixes switching from SQL to design view problem. Hope Microsoft team will fix all the issues permanently in near future.
It's already fixed in the Beta version of Access apparently (see my reply above).
