I have connected LibreOffice Base to an SQL server and am able to add tables. The image below shows that I am able to add Table1.
When I go to use Table1 using the query design view, it does not show up as an option.
However, Table1 is an option in the query wizard.
How do I go about enabling Table1 to be used in the design view?