title: Calculated Field from Linked Table
body: <p>I'm using MS Access 2013.  My database has four relevant tables:</p>
  
  <pre><code>Table A) Numerical_Key_A, {Other Data Items}
  Table B) Numerical_Key_B, "Adjustment Value", {Other Data Items}
  Table C) Numerical_Key_C, {Other Data Items}
  Table D) {Other Data Items}, Link-to-B, Link-to-A, Link-to-C
  </code></pre>
  
  <p>The way it works, however, is that the Link-to-C going into a record of Table D is always exactly "Adjustment Value" away from Numerical_Key_A.  As such, I would like to make the Link-to-C be automatically calculated when I enter Link-to-A and Link-to-B.</p>
  
  <p>As far as I can tell, this would require Table D having a Calculated Field that gets its data from the linked Table B, which Access does not allow.  Is there another way to do this?  I'd prefer not to use VBA if possible, but if it's the only way, I'll just have to learn how to do it. (I know VBA for Excel, but have never used it in Access before).</p>