Hi has anyone used this feature and if so you help me?

In the phpMyAdmin
documentation, it mentions some support of relationships - foreign keys -
for mySQL. It has the following:

$cfgServers[$i]['relation'] string
Since release 2.2.4 you can describe, in a special 'relation' table, which
field is a key in another table (a foreign key). phpMyAdmin currently uses
this to make clickable, when you browse the src table, the data values that
point to the dest table;
display links on the table properties page, to check referential integrity
(display missing foreign keys) for each described key.

The keys can be numeric or character.

To use this functionality you have to:
create in the same database a table (for example 'relation') following this
scheme:
CREATE TABLE `relation` (
`src_table` varchar(32) NOT NULL default '',
`src_column` varchar(32) NOT NULL default '',
`dest_table` varchar(32) NOT NULL default '',
`dest_column` varchar(32) NOT NULL default '',
PRIMARY KEY (`src_table`,`src_column`)
) TYPE=MyISAM COMMENT='Table Relation';

put the relation table name in $cfgServers[$i]['relation'] then manually
fill the relation table with information about the keys.


Have you ever used this feature before? I can create the relation table, but
I'd have to figure exactly how to fill in the informaton about the keys. I
think you would have to put the relation table name in
$cfgServers[$i]['relation'] , wouldn't you? If so can you tell me how to do it.