Benefiting from the Relational System - Mastering phpMyAdmin 3.4 for Effective MySQL Management - page 194

The browseable foreign-table window
Our current author table has very few entries. Thus, to illustrate this mechanism, we
will set the $cfg['ForeignKeyMaxLimit'] to an artificially low number, 1. Now in
the Insert mode for the book table, we see a small table-shaped icon and a Browse
foreign values link for author_id column. This icon opens another window, which
will present the values of the author table and a Search input field. On the left, the
values are sorted by key value (here, the id column), and on the right, they are sorted
by description.
Choosing one of the values (by clicking either a key value or a description) closes this
window and brings the value back to the author_id column.
Referential integrity checks
We discussed the Operations page and its Table maintenance section in Chapter 9.
For this exercise, we suppose that both the book and author tables are not under
the control of the InnoDB or PBXT storage engine. If we have defined an internal
relation for the author table, a new choice appears for the book table— Check
referential integrity .