title: Need to Create a Table that has references another table and has variables
body: <p>I need to create a table that has the following features:</p>
  
  <ul>
  <li>An employee number that references the employee number on the employee table </li>
  <li>I need to add a salary field 
  <ul>
  <li>the salary is based upon hire date which is also in the employee table</li>
  <li>if employee is hired less then 3 years then salary would be 30k </li>
  <li>less than 5 then it is 45 k </li>
  <li>and 5-10 55 k more than 10 60 k </li>
  </ul></li>
  <li>it needs to have tax info where if the employee lived in Alaska, there is no tax otherwise tax by state</li>
  <li>this is also a field on the employee table </li>
  <li>the net pay is 90% if the person has no tax and 75 % if they have a tax </li>
  <li>pay date must be a future date</li>
  <li>check number must not be null or duplicate </li>
  </ul>
  
  <p>Any help will be appreciated as I'm not sure where to begin. A UDF function?  Copy the employee table somehow and add the fields I need?</p>