Summary field in portal
I am trying to add to the complexity of a current database that I have which is a carnival management program. Currently I am only able to record a single carnival but I would like to be able to have a database that records all of the carnivals that we run.
I think I have the nuts and bolts of it worked out but I have so far hit a wall with a historical record of points for an athlete. I am wanting a portal on the athlete page that shows a history of the carnivals they have competed in and how many points they accumulated for that carnival. Currently I have the portal based on the Carnival Info table. I have tried using a summary field and a calculation field but to no joy. all i get is there overall points accumulation.
Any help will be appreciated
My current set up is