title: How to structure a database to take input and assign applicable questions appropriately
body: <p>I am creating a database that will feature the following information and need to accomplish the following goals.</p>
  <h1>Information:</h1>
  <p><strong>Customer Name</strong><br />
  e.g. &quot;Otter's Wash Co&quot;</p>
  <p><strong>Customer's Project Name</strong>.  <em>One customer could have many projects.</em><br />
  e.g. &quot;Fur Shur Wash&quot;</p>
  <p><strong>Project Elements</strong> with checkboxes to add them to the report. <em>Elements may or may not apply to all projects, but the <strong>answers</strong> will be specific to each separate project.</em><br />
  e.g. &quot;Bus Wash&quot;</p>
  <p>---Some project elements would need to have follow-up questions.<br />
  e.g. For &quot;Bus Wash&quot;, further determine &quot;Dropdown options: School bus, Party bus, Church bus&quot;</p>
  <h3>Goal:</h3>
  <p>Generate a report that shows the Customer Name, Customer Project (I can do this part so far), and [a list of information based upon the Project Elements] &lt;-- this is the part that I am struggling with how to do.  Especially with how to structure the follow-up questions.</p>
  <h3>For example:</h3>
  <p>If a Project Element is &quot;Bus: School bus&quot;, it would display a specific set of information on the report about school busses.</p>