G
Guest
I have a many-to-many relationship between tblPlanInfo (with PlanID the
primary key) and tblProjectInfo (with ProjectID the primary key). To join
them, I have tblPlanJoinProject.
*****What I want to have happen (from most important to least important)*****
1.) I want a user who is looking at the plan details (in frmPlanDetails) to
see a list of Projects associated with that Plan, along with some basic
information for each of those Projects (such as Project Name and Status)
2.) I want the user to be able to associate other (new or existing) Projects
that may need to be added to this list, or to remove Projects from the list.
They shouldn't be deleting the project, only the association with that plan.
3.) I want all the information seen to be accurate and up-to-date.
I’m hoping someone can point me down the right path to accomplish all these
goals.
Currently, I'm using a subform in continuous view that's based on
tblPlanJoinProject. This allows me to easily add or remove associations.
However, the additional information that I want to display is maintained in
tblProjectInfo. The continuous view prevents me from using another subform
or list box to display the information from a query; instead, I use a DLookup
to copy the information from tblProjectInfo to otherwise useless fields in
tblPlanJoinProject. Once in tblPlanJoinProject, the information remains
static, so it won't display any updates made in tblProjectInfo (I have an
OnOpen event for frmProjectDetail, but this only updates the first Project
listed, not all of them).
I know I could use a list box or combo box based on a query to display
updated information (accomplish goals 1 and 3), but don't see how I can add
or delete associations with this method (goal 2).
So again, any help is much appreciated.
primary key) and tblProjectInfo (with ProjectID the primary key). To join
them, I have tblPlanJoinProject.
*****What I want to have happen (from most important to least important)*****
1.) I want a user who is looking at the plan details (in frmPlanDetails) to
see a list of Projects associated with that Plan, along with some basic
information for each of those Projects (such as Project Name and Status)
2.) I want the user to be able to associate other (new or existing) Projects
that may need to be added to this list, or to remove Projects from the list.
They shouldn't be deleting the project, only the association with that plan.
3.) I want all the information seen to be accurate and up-to-date.
I’m hoping someone can point me down the right path to accomplish all these
goals.
Currently, I'm using a subform in continuous view that's based on
tblPlanJoinProject. This allows me to easily add or remove associations.
However, the additional information that I want to display is maintained in
tblProjectInfo. The continuous view prevents me from using another subform
or list box to display the information from a query; instead, I use a DLookup
to copy the information from tblProjectInfo to otherwise useless fields in
tblPlanJoinProject. Once in tblPlanJoinProject, the information remains
static, so it won't display any updates made in tblProjectInfo (I have an
OnOpen event for frmProjectDetail, but this only updates the first Project
listed, not all of them).
I know I could use a list box or combo box based on a query to display
updated information (accomplish goals 1 and 3), but don't see how I can add
or delete associations with this method (goal 2).
So again, any help is much appreciated.