I’m wondering if anyone knows a way to solve this issue that I’m having with my ‘Employees’ table containing 12 unwanted destination links.
Current Base Setup:
Table 1: Employees
Table 2: Client Groups (for entities that are in the same family group)
Table 3: Client Entities (one record for each entity in the above Client Group)
Table 4: Jobs (for client jobs at an entity-level. Has linked records to all three tables above)
Number of Linked Records to Employees table:
Client Groups table: links 5 times to Employees table
Client Entities table: links 3 times to Employees table
Client Jobs table: links 4 times to Employees table
Each linked record represents a role that an employee plays at that level.
E.g., an employee linked at the ‘Client Groups’ level (Table 2) with the role ‘Reviewer’ will be the primary reviewer for all work related to that client group.
The same goes for an employee linked at the ‘Client Entities’ level (Table 3) with the role ‘Reviewer’ - they will take care of all review work for that client at the entity level.
These fields are then used at the ‘Jobs’ level (Table 4) to delegate work to an Assignee (the ‘Assignee’ field is yet another linked record to the Employees table). A lookup at the ‘Jobs’ level won’t work because some jobs are ad hoc and require unique assignments (each role has a unique linked record field which I use to automate the job Assignee based on role).
Result of this Base design:
My Employees table has 12 linked record fields which clutter my table.
Am I doing something horribly wrong to make my Employees table have 12 linked columns which aren’t ever consciously interacted with by users? Any suggestions welcome!