title: Inserting data into a MySQL table using PHPMyAdmin
body: <p>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.</p>
  
  <p>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. </p>
  
  <p>Unfortunately this is all I see when I'm in the Parent table:</p>
  
  <p><img src="https://i.stack.imgur.com/47MOA.png" alt="enter image description here"></p>
  
  <p>There is nothing to allow me to choose data from the child tables.</p>
  
  <p>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?).</p>
  
  <p>I'm kind of hoping that I'm not just going to have to write a .php page to do the same thing.</p>
  
  <p>Thanks a lot.</p>
  
  <hr>
  
  <p><strong>Update:</strong> When exported the FK declarations look like this (i.e. fine, as far as I can tell):</p>
  
  <pre><code>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;
  </code></pre>