Databases Reference
In-Depth Information
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:
The Drop-Down List of Foreign Keys
Going back to the
book
table, in
Insert
mode (or in
Edit
mode), we now see a
drop-down list of the possible keys for each field that has a relation defined. The list
contains the keys and the description (display field) in both orders: key to display
field, and display field to key. This enables us to use the keyboard and type the first
letter of either the key or the display field:
Only the key (in this case
1
) will be stored in the
book
table. The display
field is only there to assist us.
By default, this drop-down list will appear if there are a maximum of 100 rows in the
foreign table. This is controlled by the following parameter:
$cfg['ForeignKeyMaxLimit'] = 100;
For foreign tables bigger than that, a distinct window appears: the browseable
foreign-table window.
Search WWH ::
Custom Search