Automatically select a table derived from the query #99
Description
When I'm viewing a table and I enter a query for an unrelated table the query fails.
I was wondering if it's possible to derive the table from this query and automatically select te correct table and execute the query.
Eg when I'm viewing table1 and I enter in the query:
table2.field = "X"
the underlying query will be faulty:
for each table1 where (table2.field = "X") no-lock
Seeing as this is never correct, might as well automatically switch to table2 and execute the query.
Also, I think this might save some time as in the user doesn't need to select the table anymore but can start typing straight away.