I have an existing database with a “projects” table. I have it working with a one-to-many relationship with a client table. I have multiple projects with the same client.  I need to update the projects table to include an additional one-to-many relationship to include several project managers working on the same project, i.e., architect, mech. engineer, elec. engineer, etc. Can you please point me in the right direction with the necessary videos I need to watch?  (Please don’t say all) I have watched Access 201 and 203. Thanks.

---

Reply from Richard Rost:

All. :) Ha ha ha.

Seriously, you just need to do the exact same thing again. You already have a one-to-many from Clients to Projects. Now you need a one-to-many from Projects to Managers.

So, set up a Managers table. Add a ManagerID to your Project table. Create a subform in your Project form (or even a simple listbox) that show the Managers. The design layout is up to you.

The only problem you might run into is that you can't have a subform on a CONTINUOUS form. So if you already have a main form with your client, and then a subform showing his projects, you can't have another subform inside of that subform.

I would just have a CLIENT form with a listbox showing projects. Double-click on the listbox to open another form showing that specific project. That form could have another listbox showing the managers, etc.

Sound good? You should already know how to do all of this if you've successfully built the previous relationship OK.