Automatically select a table derived from the query

[steven-peeters1]

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.