In this section, we will look at the benefits of the defined relations that we can currently test. Other benefits will be described in chapters 13 and 15. Additional benefits of the linked-tables infrastructure will appear in chapters 14 and 16.
These benefits are available for both internal and foreign key relations.
Let's browse the
book table by entering the Search subpage 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
Clicking on the author_id brings us to the relevant table—
author—for this specific author: ...