Integrating fields from many tables into one central table.

Question

I have started working on my app.&nbsp; I have three tables.&nbsp; Employees, Department, and Positions.
I want fields from department and positions to show up as fields on the employees table.&nbsp; I have&nbsp; the relationships built.&nbsp; Parent (Department) - Child (employee) and Parent (Positions) - Child (Employee).&nbsp; I have setup the table to table relationships and specified which fields I would like to be lookup fields on employee form.&nbsp;&nbsp;
My issue is that they will not populate the field on the employee form.&nbsp; I know I must be missing a step but not sure what that is.&nbsp;&nbsp;
Any suggestions?------------------------------Tracy Woodard ------------------------------

mannyde_la_cruz · Answer

Hi Tracy!&nbsp;

You've made some awesome progress! Love to see it (:&nbsp;
Today we will be covering a bit of that on the curriculum. I will be showcasing it in a "dummy" space tracking app but I know it will get your brain thinking in the right direction. If it doesn't, we can always circle back to it in the office hours or offline after the class!&nbsp;
My best guess is that we need to establish the links between those specific records and thats why we arent seeing any fields being referenced out - I'll point this out in todays lesson too and call it out for you as well!&nbsp;
Chat soon!&nbsp;

Your Quickbase Cosmic Guide,&nbsp;
-Manny------------------------------Manny De La CruzCS Team LeadQuickbase------------------------------

Forum Discussion

Integrating fields from many tables into one central table.