title: Creating relations one table to many tables using a two-field primary key
body: <p>I'm not a pro (and don't speak english very well) but I'm trying to create a relation between a table and 5 other tables using a primary key of two fields.</p>
  
  <p>I don't know if it's possible and if it's the right way to do what I want, so every suggestion is appreciated.</p>
  
  <p>This is what I thought:</p>
  
  <pre><code>TabA    TabB    TabC    TabD    TabE
  Id           Id           Id           Id           Id
  .......    .......    .......    .......    ....... (other fields)
  
  EventsTab
  TabRif
  IdRif
  ....... (other fields or not?)
  </code></pre>
  
  <p>EventsTab Primary Key = (TabRif, IdRif)</p>
  
  <p>Now, assuming that in TabA there is an Id = 3, in EventsTab the primary key will be "A3".
  How can I link this value as foreign key? Is it possible? Is the right way?</p>
  
  <p>Thanks in advance for your time.</p>