...
Step 1- Right click on the catalogue, Select 'Add' the 'Add a new lookup table relationship'
Step 2- A new window will appear. In the box at the top select the file to join from the drop down list. The columns will appear below it. The linking item needs to be dragged down to the first primary key box on the right.
Step 3- The catalogue that is being joined to features on the bottom left the joining column (in this case 'ReadCode') needs to be dragged to the far right 'Foreign Key' box.
Step 4 - From the top box (Lookup table) drag the description column down to the large box on the right hand side marked as 'Descriptions'.
Step 5 - The 'Create Lookup' box will change from grey to blank and the smiley face will appear. Select this and the description column will appear within Biochemistry
Step 6 – To finish off, you will notice the new descriptive field is marked 'yellow' for supplemental, this means that it will not automatically appear to extract. Right click on the column and select 'Set Extraction category'
Step 7 - From the pop up box select the 'Extraction Category', in our case we want this as 'Core' Then select 'ok'