Choose Users for projects
Good morning. I have an Employees Table, and a projects table. I set up a relationship where where 1 employee has many projects. But I need the project to have 2 drop downs - one where I choose a ...
Forum Discussion
Allison,
As long as you only have Sales Reps and Project Managers, I would do it the way George said.
However what if you have Auditors, Marketing Lead, Customer Liaison and Engineering Rep?
Then I would move to this:
This lets you have an unlimited number of people all defined by the Team Roles.
George's method makes a lot of reporting easier, you do not have to click Add Project Team and so on. However a big team really needs a different architecture.
------------------------------
Don Larson
------------------------------