access - Forms and Sub Forms

My OS is win 10 Prof 64 bit and I use Office 365's Access.
I am trying to create a simple volunteer dbase for my NGO but am having difficulty in linking the Sub Forms.
Basically, the db will hold Volunteers who volunteer for an Event, and the service available to volunteer are numerous.
Thus, the 3 tables that I have are : 1- tblEvents; 2-tbl Volunteers and 3-tblSewa (aka Service)
The sample file is attached.
So. a Volunteer, like Mr. A, could volunteer for an Event from the tblEvents, and select more than one Sewa opportunities.

I am trying to create a Main Form, with the Sub Forms embbeded, but having trouble linking them,  Hope the Experts could please take a peek  at the file and make the suggested corrections, as it has been ages since I did this.

Thank u and Regards
Event-Schedules.accdb
jegajothyretiredAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John TsioumprisSoftware & Systems EngineerCommented:
Hello..here is a quick and dirty sample sample of how i would go with project...needs a lot...especially formatting but this is what i done while eating me bagel..:)...go to EventsMain form.
Event-Schedules.accdb
0
jegajothyretiredAuthor Commented:
In response to John, thank u for your contribution.  In trying to understand how u tackled it, if u can find the time, hope u can pse give me some documentation.  thank u
0
John TsioumprisSoftware & Systems EngineerCommented:
Well the documentation ...is reading ...a lot of reading...the trickiest in this specific form is the "fake" master field that connects the VolunteersofTheEvents to the services that each one will provide..
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

jegajothyretiredAuthor Commented:
In response to John, let me go thru more times and understand your design.  Meanwhile thank u
0
John TsioumprisSoftware & Systems EngineerCommented:
glad to help u
0
jegajothyretiredAuthor Commented:
Thankj u for your very helpful sample file, it gives me an insight to the design. Regards.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.