Cant seem to get this right!
I have 2 tables:
Date (drop down)
Operative (drop down referring to Operative Database:Name Field)
Site (drop down, referring to Site List:Site Name Field)
Site List, which consists of these fields:
So the idea is we can log what site each operative has attended and for how long, on a specific day.
I want to add a field on the Site List which will automatically calculate the total amount of hours registered against that specific site. So if I had 3 operatives on Site A for 10 hours it would show 30 hours. The next day if the same happened, 60 hours.
How do I do this?