Table Relation

[XXPCMXX]

I am using phpmyadmin and I am trying to build a table relation. Does anyone know how to do this?

Thanks

-Mike

[devinemke]

from the manual

...create a table following this scheme: 
     CREATE TABLE `pma_relation` (
       `master_db` varchar(64) NOT NULL default '',
       `master_table` varchar(64) NOT NULL default '',
       `master_field` varchar(64) NOT NULL default '',
       `foreign_db` varchar(64) NOT NULL default '',
       `foreign_table` varchar(64) NOT NULL default '',
       `foreign_field` varchar(64) NOT NULL default '',
       PRIMARY KEY (`master_db`, `master_table`, `master_field`),
       KEY foreign_field (foreign_db, foreign_table)
     ) TYPE=MyISAM COMMENT='Relation table';

put the relation table name in $cfg['Servers'][$i]['relation']
now as normal user open phpMyAdmin and for each one of your
tables where you want to use this feature, click "Structure/Relation view/" and choose foreign fields.