Hi Richard, I hope you can help me figure out how to go about designing this. Here is what I'm trying to do.
I have CD's number 1-7
I have Libraries and each library has its own name (short Text)
And I have Maps each map has its own name (short Text) and a group or maps makes a Library. For example Cd1 contains Library 1221 which contains maps 2,3,4,5,6
One library could have many charts
One CD could have many Libraries
One chart could have many Libraries
So I need to do is build a database that tracks the updates done to a library. I  need an Employee table, A project assignment table and a project table-If a map needs to be updated that library would become a project that needs to be assigned to an employee. So the assign form Would have the library name as the project, The employee who is assigning the project, The employee who the project is assigned to, and the date it was assigned. I want this form to also have a way that the employee assigning the project could select maps from a list and have the populate in a subform. So If you select a library- you get a list of all the maps in that library and you can choose the maps from the list that need to be updated.
Once that form is complete in another form called the Project form populates the projects that were assigned to each employee. That form will then tack the status of the project.
I know this was a lot but writing it is much harder than it sounds.

---

Reply from Alex Hedley:

Which bits do you need help with?
It's good to draw out a map of your Tables and how they connect.