[FIXED] Setting foreign key in phpMyAdmin

Issue

I want to make namecon of table "paper" as a foreign key reference to table "journal" to its primary key jname. I am getting confused with this view and not finding any tutorial or link which is explaining to set foreign key with this schema of phpMyAdmin. (Is it new or what) Please someone let me to figure this out.

Solution

While making the foreign key, it is also advisable to mark the index key option available int Structure view of the table. That will make the primary key thing to visible in the relational view of that particular table which can be used for making foreign key.

Answered By - hawkeye