CODEWITHSUNDEEP
mysqlphpmyadminrelationship
ThePetr
ThePetr

Reputation: 31

Can't make relationship with phpMyAdmin

Whenever i try to make a relationship, i only get an empty pop-up and nothing happens... How can i solve this?

Upvotes: 3

Views: 6477

Answers (2)

Barry Staes
Barry Staes

Reputation: 4125

I had the same problem.

Fix: add index to the referenced column

Go to the table structure, and click Index once. Then you'll see it listed if you select the table's index in the left-hand menu. I had the refresh the whole page. Then go to designer and add relation. I had to refresh the whole page once more before seeing the lines appear.

Upvotes: 3

Halcyon
Halcyon

Reputation: 57723

Make sure you have InnoDB tables as you can not make relations on MyISAM tables.

Upvotes: 1

Related Questions