Jegajothy vythilingam
asked on
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
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
ASKER
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
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..
ASKER
In response to John, let me go thru more times and understand your design. Meanwhile thank u
glad to help u
ASKER
Thankj u for your very helpful sample file, it gives me an insight to the design. Regards.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Event-Schedules.accdb