System for viewing databases

A non-transitory computer readable medium carrying computer-readable instructions for expressing related database information comprising:

• receiving a defined linkage to a first database query result from a user;
• displaying the result of a first database query in a first pane including a table including data;
• automatically generating, for a second pane, a second database query by running the defined linkage to the first database query result using a parameterized query associated with the second pane, the parameterized query, employing a reference to the first pane and an indicator of the selected record within the first database query result;
• and
• wherein automatically generating the second database query includes employing an indicator of the selected record within the first database query result as a parameter in the automatic generating a second database query;
• wherein automatically generating a second database query includes running a defined linkage to the first database query result;
• receiving the defined linkage from user input;
• expressing a second database query result corresponding to the second database query;
• wherein the first database query is different than the second database query;
• and
• wherein the second database query result includes a table with data related to and different that data in the first database query result.

A method comprising:

• establishing a first window having records of a database corresponding to a first query of the database;
• establishing a second window having records of a database corresponding to a second query of the database different than the first query;
• establishing a defined dynamic linkage between records query in the first window and records in the second window including a parameterized query statement received from a user to automatically perform the second query of the database corresponding to the second window, the second query employing an indicator of a selected database recorded within the first window as a parameter, wherein the records displayed in the second window are selected automatically responsive to a selection of at least one record in the first window according to the dynamic linkage to the selected at least one record displayed in the first window;
• and
• wherein the database records of the first window and the database records of the second window are records from first and second databases, respectively.

A non-transitory computer readable medium carrying computer readable instructions for viewing databases to cause a computer to execute steps comprising:

• establishing a first window having records of a database;
• establishing a second window having records of a database;
• establishing a defined dynamic linkage between records in the first window and records in the second window including a parameterized query statement received from a user to automatically perform, the second query of the database corresponding to the second window, the second query employing an indicator of a selected database record within the first window as a parameter;
• and
• wherein selection of a record in the first window automatically determines the records displayed in the second window according to the defined dynamic linkage;
• wherein the database records of the first window and the database records of the second window are records from first and second databases, respectively.