title: Order Tables Schema Issue
body: <p>I have two tables Order_Primary and Order_Complete the problem is when I want to generate the bill there could be multiple products in the bill in the Order_Primary table, so it will generate OrderId for each single product though they are from the same bill, now how should I associate all these OrderId in Order_Complete table as there will be multiple OrderIds for the same product but there has to be only one BillNo</p>
  
  <p>Order_Primary</p>
  
  <blockquote>
    <p>OrderId (Primary Key)<br />
    ProductId (Foreign Key)<br />
    CategoryId (Foreign Key)<br />
    Quantity <br />
    Cost <br />
    EmployeeId (Foreign Key)</p>
  </blockquote>
  
  <p>Order_Complete</p>
  
  <blockquote>
    <p>BillNo (Primary Key)<br />
    OrderId (Foreign Key)<br />
    Date</p>
  </blockquote>