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!