For a medical system I need to select a group of patients from a master table and load/stuff a table or grid with some of the fields from the master table....easy enough using Select SQL BUT if a field in the master table contains a value which is related to a look-up table, i.e. Region '1' which is actually 'North-East' in the related table, HOW can I transfer 'North-East' into the search results instead of '1'.

At the moment I am doing the Select SQL which transfers raw data from the master table then loading another table with related data etc which takes time

Any ideas please anyone?