Add "Related Tables" option in Visual Query Builder
I often work with multiple very large databases with hundreds of tables and need to write queries involving multiple tables that I am not familiar with - typically, I can fairly quickly find one or two tables that I know are relevant to my query, but finding the entire chain of joined tables is very time consuming. It would be *extremely* helpful to have the ability within the Visual Query Designer to (instead of just choosing "Add Object") right click a table on the query canvas and choose "Add related table" which would open a window showing only the tables that are related (via foreign key declarations). An additional nice feature would be if it showed the type of relationship (1:1, 1:many, Many:1) beside each table.
This feature is very similar to the "Show Direct" function in MS Access.
Will be ready soon.