Hi All,
I'm fishing for some ideas on how to structure my Project Tracking Base. Here's what I'm trying to do:
I have Projects in a table, with a Project Manager, and Team members assigned from my People table. I do want to keep track of the role of each person on each project. This role can be different for each project they are working on, so assigning them to Departments or Roles in the People Table does not work.
I'm hoping to not have to create another table (let's call it Roles for now), since it I think it will complicate the Interface. I want people to simply add team members to the Project in pre-defined roles.
The other way of doing it (easier interface) means having a field in the Projects table for each role. Trouble with this approach is that new roles keep on being added (as needed on projects), and I can't be editing fields, forms, interfaces, etc. each time a new role is needed.
Any suggestions on a better way to structure my base to accommodate that?
