Portal to Show all related Sponsors and allow New Donations
This is something I haven't been able to figure out for the life of me.
I have four tables:
"Regions" which feeds "Events" and "Sponsors"
"Events" and "Sponsors" feed into a join table called "Donations"
What I'd like to do is have a portal on my Events layout that lists all of the Sponsors (this part is easy) but then also have access to the "donation amount" and "donation date" field from the "Donations" table.
The way this would be used is somebody would create a new Event, pick the region it belongs to, and then have a portal that lists all of the sponsors/phone numbers/etc assigned to that region. They can call the sponsors, if they donate, they can enter the donation date/amount and it creates a new record in the "Donations" table. If they don't donate, nothing is recorded, and no new record is created. Is there a way to do this without scripting it?
From there, I can create a relation from the donations table to the events table and sum all donations for that particular event.
I've attached a simplified screenshot of what's going on.
If you have any questions, let me know, otherwise, thanks in advance.