title: Delete from linked tables ms access
body: <p>I have a <code>MS Access DB</code> that has several tables.</p>
  
  <p>My main table is called <code>Client</code>, which is linked to another table called <code>Abonament</code>, among others.</p>
  
  <p>Both tables share the same field named <code>client_id</code>, which contain identical id's.</p>
  
  <p>Table named <code>Abonament</code> has another <strong>field</strong> named <code>data_expirarii</code> which contains dates.</p>
  
  <p>How do I delete all the entries from both tables (<code>Client</code> &amp; <code>Abonament</code>) based on a specific date in <code>data_expirarii</code> <strong>field</strong>, from the <code>Abonament</code> table?</p>
  
  <p>I've managed to delete them from the <code>Abonament</code> table using the Design Wizard and subsequently deleting every entry below or equal to <strong>1-Jun-17</strong> (<code>&lt;= 1-Jun-17</code>) but the client entries remain in the <code>Client</code> table. MS Access gives me a headaque.</p>