title: How to Make a CRUD with Relationship between more than 1 Table - GroceryCRUD
body: <p>I have a simple question here regarding GroceryCRUD.</p>
  
  <p>The question is: Is there a way to build a CRUD using Grocery when I have multiple relationship (JOINs)? For example: I want to have a CRUD for the following:</p>
  
  <p><strong>Table QUESTIONS</strong> <br>
  IDQuestion <br>
  IDRightAnswer <br>
  IDKnowledgeArea <br>
  Question <br>
  IDExplanation <br></p>
  
  <p>One Record in this table would contain: <br>
  IDQuestion IDRightAnswer IDKnowledgeArea Question <br>
  10---------------2----------------------<strong>3</strong>---------------------------What is the color of the sun?        </p>
  
  <p>Table KnowledgeArea <br>
  <strong>ID</strong>------------<strong>Name</strong><br>
  1--------------Phisics<br>
  2--------------Math<br>
  <strong>3</strong>--------------<strong>Astronomy</strong></p>
  
  <p>So, as this is normalized table, for those IDs (except for IDQuestion cuz it is PK and IDRightAnswer cuz its a FK) which is/are FK in the Questions table, I would like to have the correlated values (text) from Original table displayed in the grid rather than the ID itself.</p>
  
  <p>So, using the same example, for the column <strong>IDKnowledgeArea</strong> in the table Questions (its a FK here) the CRUD would bring a combobox with the original values (text) in the table <strong>IDKnowledgeArea</strong> then I could chose it from there. </p>
  
  <p>For example:</p>
  
  <p><strong>IDQuestion</strong> <strong>IDRightAnswer</strong> <strong>IDKnowledgeArea</strong>    <strong>Question</strong><br>
  10---------------2-----------------------<strong>Astronomy</strong>-------------What is the color of the sun?        </p>
  
  <p>All the CRUD tools I've seen doens't have such resource and although they provide good CRUD approach they never address this multi-relationship between the entities.</p>
  
  <p>I appreciate any answer.
  Thank you</p>