How can I enforce relationships in mysql? For example, I want "link" two fields together (pkey in one table with fkey in another table) so that it is impossible to insert a record which has an invalid value for a foreign key.

Is this possible in phpmyadmin?