Hi,
I am trying to create a query with SOD using three tables. The main table is the Value Entries table and then I want to joint to the customer table to obtain the customer name and also the item table to obtain the item description, but when I try and add the item table I get the message “New elements must be inserted at the end of the query.” and I cannot work out how to add it.
See attached screenshot.
Thanks
Jonathan
Question is closed for new answers.
Jonathan Ellis Selected answer as best April 15, 2025
It’s a correct limitation of the query editor. It will not accept 2 tables at the same level.
Sorry about that.
Jonathan Ellis Selected answer as best April 15, 2025