Viewing Related Tables
Multiple tables can be opened at once. Here we're about to open 'SalesOrderDetail' under 'SalesOrderHeader' by double-clicking or pressing the Enter key:
Here's the result. Both tables are opened and they're automatically linked. At the moment SalesOrderDetail is the "leader" and is showing all of its rows. SalesOrderHeader is a "follower" and is showing the row corresponding to the currently selected detail row:
As we scroll down through SalesOrderDetail the corresponding SalesOrderHeader row is continously updated to match:
We can change which table is the current "leader". Here we've right-clicked on the SalesOrderHeader title bar:
After clicking on "Make SalesOrderHeader the Lead Table" in the above screen we get the following. Now we're seeing all SalesOrderHeader rows, and the SalesOrderDetail window automatically shows the detail rows matching the currently selected header:
Many tables can be displayed at once in a single DataRoamer window. When there's a relationship among them, DataRoamer uses it. Here we've gone back to the 'Database Structure' and we're about to double-click on 'Person.Contact':
And here's the result after shrinking the 'Database Structure' and clicking on SalesOrderId 43660 in SalesOrderHeader. We're automatically shown that the contact for this order is Takiko J. Collins, and that there are two detail items for this sales order:
