title: How do I create a foreign key in access?
body: <p>I have the following code:</p>
  
  <pre><code>CREATE TABLE Faculty (
  FacSSN text(9) primary key,
  FacFirstName Text(30) null,
  FacLastName Text(50) null,
  FacCity text(50) null,
  FacState text(2) null,
  FacDept text (6) null,
  FacRank text(6) null,
  FacSalary currency null,
  FacSupervisor text(9) null,
  FacHireDate datetime null,
  facZipCode text(9) null,
  offerNo text(6) ,
  
  FOREIGN KEY offerNo REFERENCES ClassOffering (OfferNo)
  
  );
  </code></pre>
  
  <p>I have another table called ClassOffering created with "OfferNo" already in it.  I need to create a foreign key in the table above that 'links' to ClassOffering.  I am using Access. </p>