title: Can't insert values into table, foreign key constraint keeps failing
body: <p>I'm trying to insert this code into my Albums table on my MySQL database</p>
  
  <pre><code>INSERT INTO `Albums` (`Albumid`, `Name`, `Numberoftracks`, `Artistid`,     ]
  `Genre`) VALUES (1, "Innuendo", 12, "Queen", "Rock");
  </code></pre>
  
  <p>But every time I try to I keep getting this error.</p>
  
  <pre><code>1452 - Cannot add or update a child row: a foreign key constraint fails 
  (`b4014107_db1/Albums`, CONSTRAINT `Albums_ibfk_1` FOREIGN KEY (`Artistid`) 
  REFERENCES `Artist` (`Artistid`))
  </code></pre>
  
  <p>I know it's something to do with my foreign key within the table, but I need to manually enter the foreign key because it's not auto-incremented. </p>
  
  <p>Here's the tables code. </p>
  
  <pre><code>CREATE TABLE `Albums` (  `Albumid` int(6) NOT NULL,  `Name` varchar(50) NOT 
  NULL,  `Numberoftracks` int(11) NOT NULL,  `Artistid` int(6) NOT NULL,  
  `Genre` varchar(50) NOT NULL,  PRIMARY KEY  (`Albumid`),  KEY `Artistid` 
  (`Artistid`),  CONSTRAINT `Albums_ibfk_1` FOREIGN KEY (`Artistid`)   
  REFERENCES `Artist` (`Artistid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1
  </code></pre>
  
  <p>How do I fix this? I need to input data into the table.</p>