This is a bit of a newb question, so apologies if the answer is really obvious. I have a bunch of InnoDB MySQL tables set up with Foreign Key restraints. This is all fine, as far as I can tell, however I'd like to use it to insert data into the database.
I was hoping I would be able to use a dropdown menu, since I should, in theory, be unable to enter any data into the Parent table that the Child table doesn't already have.
Unfortunately this is all I see when I'm in the Parent table:
There is nothing to allow me to choose data from the child tables.
How do I use this feature? And is it possible to see the contents of a different column (e.g. When picking "EventID" being able to see "EventName" from the same table?).
I'm kind of hoping that I'm not just going to have to write a .php page to do the same thing.
Thanks a lot.
Update: When exported the FK declarations look like this (i.e. fine, as far as I can tell):
ALTER TABLE `Nominations`
ADD CONSTRAINT `Nominations_ibfk_1` FOREIGN KEY (`FilmID`) REFERENCES `Films` (`FilmID`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `Nominations_ibfk_2` FOREIGN KEY (`AwardID`) REFERENCES `Awards` (`AwardID`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `Nominations_ibfk_4` FOREIGN KEY (`EventID`) REFERENCES `Events` (`EventID`) ON DELETE CASCADE ON UPDATE CASCADE;