Databases Reference
In-Depth Information
We might prefer to see information differently in the drop-down list. Here,
John
Smith
is the content and
1
is the id. The default display is controlled by
$cfg['ForeignKeyDropdownOrder'] = array( 'content-id', 'id-content');
We can use one or both of the strings
content-id
and
id-content
in the defining
array, in the order we prefer. Thus, defining
$cfg['ForeignKeyDropdownOrder']
to
array('id-content')
would produce:
The Browseable Foreign-Table Window
Our current
authors
tables have very few entries - two in fact. Thus, to illustrate
this mechanism we will set the
$cfg['ForeignKeyMaxLimit']
to an artificially low
number, 1. Now in
Insert
mode for the
topics
table, we see a small table-shaped icon
for
author_id
, as shown in the screenshot that follows:
This icon opens another window presenting the values of the table
authors
and
a
Search
input field. On the left, the values are sorted by key value (here, the
author_id
column), and on the right, they are sorted by description. We have added
a third author to better see the difference in sorting:
Search WWH ::
Custom Search