title: How to get referenced values from another table?
body: <p>Not being this my job, I still have only very little knowledge of SQL, my question is to get directions on how to approach this problem. I hope the question is not too generic or meaningless:</p>
  
  <p>I have several tables in a db. Few of them are basic tables, list of countries, list of customers and so on. 
  These basic tables are used to support values in dropDownLists on other grids where users use preset values for certain fields and they also fill in other fields manually. Something like this:</p>
  
  <p><img src="https://i.stack.imgur.com/q5kBv.png" alt="enter image description here"></p>
  
  <p>Now, I am working on a dynamic report that points to the table where I need to get the actual values and not the references.</p>
  
  <p>As I said, the problem I have is that those preset values in that particular table I am working on, are id_references (id_Country, id_Customer, ..) while I need the actual value they represent.
  What should I do to get the actual values? If I point my report to different tables I loose the meaning/link between the records.</p>