New Table Column based on Sum of another table column

[johncassell]

Hi There,

Hoping someone can help with this pls...

I have 2 tables 'WS_Jobs' and 'FittersJobHours'. As you can see I have created a new column through VS in the WS_Jobs table called 'CountOfFittersJobHours'

Looking at the picture below, can someone tell me what to write in the Expression field of the new column so that it returns the Count of a particular job number.

Example: WS_Jobs contains a job number '123' (PK so only appears once), but in the FittersJobHours table it appears 20 times.

I need my new column to return 20 when job '123' is loaded.

Can anyone help with this pls?

Thanks

John