title: two tables, each with a foreign key referencing the other
body: <p>I am trying to create a database to store some questions and answers for a quiz</p>
  
  <p>I have so far two tables:</p>
  
  <p><code>questions: (Question ID(PK), question string, correct answer ID)</code></p>
  
  <p><code>answers: (Answer ID(PK), answer string, question ID)</code></p>
  
  <p>I'm having trouble setting up the foreign key constraints. Surely I need to make sure that <code>correct answer ID</code> exists in <code>answers</code> and that also <code>question ID</code> in <code>answers</code> exists in the <code>questions</code> table. However, when trying to add these foreign keys in SQliteStudio, I am getting errors which suggest I cannot add a foreign key referencing table A > B when there is already a foreign key constraint that goes from B > A.</p>