Hi,
I have to InnoDB tables, and all my relational constraints are set up except for one.
In PMA, I click on Relations View, and select the appropriate primary-foreign key relationship. I select actions on delete/update like normal.
Then I submit and get back (no index defined! [for the foreign key field]).
And yet i HAVE indexed both fields!!!
The tables do have data in them but the keys all match up. Any suggestions on this?
A) there's something ovious I'm missing or
😎 the interface explaining this is poor.
Thanks.