title: How to combine 5 tables together with same ID in a query?
body: <p>I have 5 different tables T_DONOR, T_RECIPIENT_1, T_RECIPIENT_2, T_RECIPIENT_3, and T_RECIPIENT_4. All 5 tables have the same CONTACT_ID. </p>
  
  <p>This is the T_DONOR table:</p>
  
  <h2>  <img src="https://i.stack.imgur.com/nWOmv.png" alt="T_DONOR"></h2>
  
  <p>T_RECIPIENT_1:
  <img src="https://i.stack.imgur.com/0N1jn.png" alt="enter image description here"></p>
  
  <hr>
  
  <p>T_RECIPIENT_2: 
  <img src="https://i.stack.imgur.com/sL8LE.png" alt="enter image description here"></p>
  
  <hr>
  
  <p>This is what I want the final table to look like with more recipients and their information to the right.</p>
  
  <p><img src="https://i.stack.imgur.com/UCls3.png" alt="enter image description here"></p>
  
  <hr>
  
  <p>T_RECIPIENT_3 and T_RECIPIENT_4 are the same as T_RECIPIENT_1 and T_RECIPIENT_2 except that they have different RECIPIENT ID and different names. I want to combine all 5 of these tables so on one line I can have the DONOR_CONTACT_ID which his information, and then all of the Recipient's information. </p>
  
  <p>The problem is that when I try to run a query, it does not work because not all of the Donors have all of the recipient fields filled, so the query will run and give a blank table. Some instances I have a Donor with 4 Recipients and other times I have a Donor with only 1 Recipient so this causes a problem. I've tried running queries where I connect them with the DONOR_CONTACT_ID but this will only work if all of the RECIPIENT fields are filled. Any suggestions on what to do? Is there a way I could manipulate this in VBA? I only know some VBA, I'm not an expert.</p>