title: How to add a table relationship using pyodbc
body: <p>So I have two tables within a Ms Access database that have a common GUID field which I can use to link the two.  I would like to create a relationship using the common GUID without having to open up MS Access and create the relationship.  I was hoping I could do this with pyodbc since I'm running a pyodbc query already that needs the relationship in order to work correctly.  Is this even possibly using pyodbc?  </p>
  
  <p>(Incomplete) DDL for existing objects:</p>
  
  <pre><code>CREATE TABLE Customer ( CustID GUID NOT NULL PRIMARY KEY );
  CREATE TABLE FileList ( FileID GUID NOT NULL );
  </code></pre>
  
  <p>What is the syntax for creating a foreign key relationship between the <code>Customer</code> and <code>FileList</code> tables, and how can this relationship be created using <code>pyodbc</code>?</p>