Update value in field in one table based on Summary total from different table
Once again I think I am in over my head and could use some help. I have several schools for which I photograph their Sporting events, Pep Rallies, dances etc. I need to get a handle on which sports have been covered for each school. Each school has different sports that they participate in so keeping track is a nightmare. Compounded by the fact that I need to provide a certain number of images for their yearbook for each sport and sometimes it takes going to more than one game to get that many images. I need to be able to sum the number of images for each sport by school and if the required number of images is reached I want to set a status field as complete. This doesn't sound too difficult but with the table relationships I have I can't figure it out. Any help would be greatly appreciated. Here is what I have for relationships and data.