Question regarding relationships

Question

Hello,&nbsp;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, email, phone number, manager ID, and second line manager ID with my first relationship.&nbsp;&nbsp;I am needing to pull additional information back from the table once this information prefills.&nbsp;Specifically, once the manager ID and Second line manager ID prefill, I need it to loop back to the employee table and use those IDs to look up the phone numbers for the manager IDs.&nbsp;(Essentially the phones numbers are only listed by employee, so I would need to take the manager and 2nd manager ID from the first relationship and pull in their phones numbers based on the Employee ID on the employee table)&nbsp;Every time I try to add another relationship to take the Manager ID and look up the phone number, my data pulls back empty. If I delete the secondary relationship, my manager IDs pull back fine.&nbsp;&nbsp;What am I doing wrong!?!?&nbsp;&nbsp;THANK YOU!!!&nbsp;&nbsp;

bgar90 · Answer

I appreciate you! Finally got it working.&nbsp; I was missing updating the reference field *face palm*&nbsp;THANK YOU!!

markshnier__you · Answer

What is the Key field if the Employees Table? &nbsp;Then I can help.&nbsp;

bgar90 · Answer

hi!&nbsp;So the key field is the personnel number.&nbsp;So basically my first relationship brings in&nbsp;personnel number, name, phone number&nbsp; manager id, 2nd line manager ID.&nbsp;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.&nbsp;THANK YOU THANK YOU THANK YOU!&nbsp;This is my first quickbase and I have zero experience so I appreciate your help so much.&nbsp;&nbsp;

markshnier__you · Answer

OK, so this will be easy. Hopefully once you do it you will do one of those Homer Simpson "D'oh" exclamations.

Just make a second relationship and when it offers to make a new field for you instead select the field that you already have from the first relationship for the Manager ID. Then look up what you want including perhaps the Manager ID from the Manger! So like the 2nd Level Manager ID and then repeat another relationship using [Second Level Manager ID] as the reference field on the right side of the relationship. Just make real sure that you name all these fields properly so you don't confuse yourself.

markshnier__you · Answer

OK, this will be easy.&nbsp; Hopefully after you do this, you will one of those Homer Simpson type "D'oh" expressions.&nbsp;From your existing relationship pull down the Manager's personnel #.&nbsp;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 #.&nbsp; Then pull down any information you need from that relationship including possibly that Manager's Managers personal number&nbsp; and call that 2nd Level Manager Personal #.&nbsp; Then just keep repeating the process as high up the reporting chain as you like.

Forum Discussion

Question regarding relationships