Skip to main content (Press Enter).
Skip auxiliary navigation (Press Enter).
Quick Base University
Skip main navigation (Press Enter).
on this day
between these dates
Back to discussions
sort by most recent
sort by thread
Connected Table Relationships
So here is the problem I am facing: I have a connected table which has a list of all employees, no...
Hello Angel, It sounds like you may benefit from a recursive relationship in the Employee table. ...
Connected Table Relationships
Posted 09-19-2018 21:36
So here is the problem I am facing:
I have a connected table which has a list of all employees, now this table is updated and maintained externally. - and this is correctly reflected in Quickbase using Connected Tables.
Employees Table- connected table
Association Table- manually created table
What am I trying to do?
I have created an Associations table- the purpose of this is be able to look up a particular employee from the Employees table (connected table) - Lets call this relationship Related Leader . - I am easily able to achieve this by creating a Employee (Master) to Associations (Details) table relationship.
Further, this chosen Leader employee may have associations with multiple other employees. I want to create a relationship that helps me lookup and list all the associated employees with the chosen Leader. - I am struggling with this part. Any help/thoughts are appreciated
In short, I want to maintain the related leader and all the employees under that leader in one view. Is there a way to achieve this?
RE: Connected Table Relationships
Posted 09-20-2018 13:36
It sounds like you may benefit from a recursive relationship in the Employee table. Employees (leaders) have child Employees. Quickbase warns you when creating recursive relationships, but they can be useful, especially in this hierarchy of Staff.
I would recommend creating a leader checkbox, to easily indicate which employees are leaders and can have child employees. You can use this checkbox in form rules to hide/show the child employee section and embedded report. I would even recommend a grid edit embedded report to select the child employees at the leader level. You would have some clean up on the form for Child employees, choosing whether to allow the selection of a leader on the child, or to hide this selection if the record is indicated as a leader record. Most likely, you want to have a clear hierarchy of Leaders and employees, not a chain of Leader>Managers>Employees>Minions. With recursion, it allows for infinite chains, and you want to set quickbase up so that it limits you to leader>Employees in the chain.
This leaves all your employees in one table, but defines a relationship that you may use in your associations table. You then have some options.
1. you can select the leader, and conditionally select an employee (based on 2 relationships to the associations table, the employee relationship conditional on the leader relationship)
2. you can select a leader on the association, and an embedded report link can show the employees related to that leader.
3. you can use the recursive relationship to define custom permission models.
There is a lot here, but let me know if it helps.
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Powered by Higher Logic