I cannot seem to link a table to another and get the value i want

[Tiger1]

I have two tables:

Nestle Log Results
Risk Table by position

I need the position column in Table 1 (Nestle Log Results) to reference Table 2 (Risk Table by postion). I did this by referencing it - it works fine.

Then i need [Risk] in Table 1 (Nestle Log Results) to give the corresponding risk value according to Table 2 (Risk Table by position) - this i cannot seem to get to work.

Screen shot of table one (Nestle Log Results):

Screen shot of reference in Table 1 in column [position]:

Screen shot of table 2:

Screen shot of the app - I need column values in [Risk] column:

Screen shot of the raw data in table 2:

My goal:

To assign a risk factor to each employee depending on their position.