The Relational System - Mastering phpMyAdmin 3.1 for Effective MySQL Management - page 183

Next, having changed the cursor to Select foreign key , we bring it to the author_id
column of the book table and click again. This confirms the creation of the relation.
Currently, the interface does not permit the creation of compound keys (having more
than one column).
Foreign key relations
The procedure to delete or define a relation between InnoDB or PBXT tables, is the
same as that for internal relations. The only exception is that, at the time of creation,
a different confirmation panel appears, enabling us to specify the ON DELETE and ON
UPDATE actions.
Defining the display field
On the workspace, we notice in the author table that the name column has a special
background color. This indicates that this column serves as the display field. We
can simply click the Choose field to display top icon, and drag the short message
Choose field to display onto another column—for example, the phone column.
This changes the display field to this column. If we were to drag the message to an
existing display field column, we would have removed this column as a display field
for the table.