Hi.
I want to build a database with Access to manage volunteers who will be helping out at a number of events. The data-entry will be contact-centric, with contacts/volunteers having one or more events assigned to them.
I've previously done similar using a one-to-many relationship between two tables: the main volunteer/contact form contains an event-subform. It's simple enough then to query all contacts assigned to any particular event.
What I really want is to understand how using a many-to-many relationship (which I guess could equally apply) would add power or flexibility to what I could do or how I could query the tables. I have the feeling it must offer advantages - but I'm not quite sure what these are.
Many thanks for your help with this one.
Cheers - Jol
I want to build a database with Access to manage volunteers who will be helping out at a number of events. The data-entry will be contact-centric, with contacts/volunteers having one or more events assigned to them.
I've previously done similar using a one-to-many relationship between two tables: the main volunteer/contact form contains an event-subform. It's simple enough then to query all contacts assigned to any particular event.
What I really want is to understand how using a many-to-many relationship (which I guess could equally apply) would add power or flexibility to what I could do or how I could query the tables. I have the feeling it must offer advantages - but I'm not quite sure what these are.
Many thanks for your help with this one.
Cheers - Jol