J
Joe
I am trying to build a form with a subform that
will allow me to do the following:
I have two tables: Agency and Volunteer. Agency
contains, among it's many columns, an AgencyID
column (it's promary key) and Volunteer contains
as it's primary key a VolunteerID column. I also
have a cross refernce table whose wolumns are
AgencyID and VolunteerID. This, of course,
matches up agencies with volunteers.
I now have a form that is supposed to allow
people to choose an agency (from a dropdown box)
and see and edit/add/delete all of the volunteers
working at that agency.
The problem that I am having is setting up the
subform for the volunteers. Iam stuck. How do I
set up the subform so that I use the cross
reference table to link the agencies with the
volunteers? Any help to guidance would be
greatly appreciated.
Thank you,
Joe
will allow me to do the following:
I have two tables: Agency and Volunteer. Agency
contains, among it's many columns, an AgencyID
column (it's promary key) and Volunteer contains
as it's primary key a VolunteerID column. I also
have a cross refernce table whose wolumns are
AgencyID and VolunteerID. This, of course,
matches up agencies with volunteers.
I now have a form that is supposed to allow
people to choose an agency (from a dropdown box)
and see and edit/add/delete all of the volunteers
working at that agency.
The problem that I am having is setting up the
subform for the volunteers. Iam stuck. How do I
set up the subform so that I use the cross
reference table to link the agencies with the
volunteers? Any help to guidance would be
greatly appreciated.
Thank you,
Joe