In this section, we will look at the benefits that we can currently test; other benefits will be described in Chapter 13 (The Multi-Table Query Generator) and Chapter 15 (System Documentation). Some other benefits of the linked-tables infrastructure will appear in Chapter 14 (Bookmarks) and Chapter 16 (MIME-Based Transformations).
These benefits are available for both internal and InnoDB relations.
Let's browse the book table by entering the Search sub-page and choosing to display the first four columns. We see that the related key (author_id) is now a link.
Moving the mouse pointer over any author_id value reveals the author's name (as defined by the display field of the author table):
Clicking on the author_id brings us to the relevant table, author, for this specific author: