Forum Discussion
EvanWestbrook
6 years agoQrew Cadet
Ivan,
If I understand correctly, it sounds like you have a couple of many to many table situations.
With many to many relationships, a "join" table might be more appropriate than relating a table to itself. For example, maybe you would have a "Supervisor Direct Reports" table to track hierarchies, and a "Employee Projects" table to track which employees are on which projects.
------------------------------
Evan Westbrook
PRIME Developer
Harder Mechanical Contractors Inc.
Portland OR
------------------------------
If I understand correctly, it sounds like you have a couple of many to many table situations.
- Many Contacts can have many Supervisors, and many Supervisors can have many Direct Reports
- Mark could report to both Larry, VP of Sales, and Cindy, VP of Operations
- Many Direct Reports can have many Projects, and many Projects can have many Direct Reports working on them
- Trucking Accounts can be worked on by Mark and Ashley, and Ashley can be working on Trucking Accounts and Baseball Accounts
With many to many relationships, a "join" table might be more appropriate than relating a table to itself. For example, maybe you would have a "Supervisor Direct Reports" table to track hierarchies, and a "Employee Projects" table to track which employees are on which projects.
------------------------------
Evan Westbrook
PRIME Developer
Harder Mechanical Contractors Inc.
Portland OR
------------------------------
IvanWeiss
6 years agoQrew Captain
Evan, thanks for the response! not quite right though. I am not referring to an internal hierarchy. I am referring to a client hierarchy. For example our largest client has the following Hierarchy:
So in essence a pyramid type of setup with (4) layers. If I pick any contact towards the top of the list I should be able to see all of their opportunities underneath them.
So if I view the President, I see the entire pyramid. If I pick a RVP I get the DM and GM opportunities reporting up to that RVP, etc.
------------------------------
Ivan Weiss
------------------------------
- President of the Division
- Multiple Regional Vice Presidents reporting to the President
- Multiple District Managers reporting to each Regional Vice President
- Multiple General Managers reporting to each District Manager
So in essence a pyramid type of setup with (4) layers. If I pick any contact towards the top of the list I should be able to see all of their opportunities underneath them.
So if I view the President, I see the entire pyramid. If I pick a RVP I get the DM and GM opportunities reporting up to that RVP, etc.
------------------------------
Ivan Weiss
------------------------------