Im not too sure if I will word this correctly but here goes... A user selects a job and assigns hours to that job, a single user can select multiple jobs and assign multiple hours to multiple jobs. I am trying to sum those hours on a per job basis which wouldnt be difficult but the field name within the job is relative to the selection made. So they could select "washing up" from the list but in the activity table washing up relates to WS001 in the washing up table and its WS001 that I am trying to tally and display not the washing up field.
Hope this makes sense? Any help is appreciated - thanks.