Question regarding relationships
Hello, I am trying to pull information in from an employee table to auto fill on my form once the employee name is selected. I have successfully pulled in the employee number, employee name, ema...
Forum Discussion
hi!
So the key field is the personnel number.
So basically my first relationship brings in
personnel number, name, phone number manager id, 2nd line manager ID.
Then I need to take the manager id and 2nd line manager id back to the employees table, find it in the personnel # field on the employees table and bring back the phone number.
THANK YOU THANK YOU THANK YOU!
This is my first quickbase and I have zero experience so I appreciate your help so much.
MarkShnier__You
Qrew Legend
Qrew LegendOK, this will be easy. Hopefully after you do this, you will one of those Homer Simpson type "D'oh" expressions.
From your existing relationship pull down the Manager's personnel #.
Then make a new relationship and instead of letting it offer to create a new field, instead select from the drop-down the Manager's Personnel #. Then pull down any information you need from that relationship including possibly that Manager's Managers personal number and call that 2nd Level Manager Personal #. Then just keep repeating the process as high up the reporting chain as you like.