Hello,
I don’t know how you could do it but here is an issue I have had from the start.
In Dynamics Nav table name in SQL server are often [company name$table name].
Usually there are several companies that are created in Nav environments.
In EasyMorph “Query Editor”, I select table and make one “visual query”.
But after that, I must swith in “Custom SQL” to change table name to make them dynamic with parameter like:
FROM [dbo].[{Company}$Sales Header]
After that I can no longer use the visual query builder.
This would be fine if there was a way to have a dynamic table name based on a parameter in visual query editor.