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.