Forum Discussion

MeaganMcOlin's avatar
MeaganMcOlin
Qrew Cadet
24 days ago
Solved

Help with Lookup Fields from Multiple Parent Tables in Quickbase Form

Hello,

I have a Quickbase app where a single child table is connected to three separate parent tables. Each parent table represents a different employee group, and the child table is set up to pull employee information from all three.

In the form for the child table, I want to be able to look up and select employees from any of the three parent tables. However, I can only select from the first parent table I connected—its lookup field is active. The lookup fields for the other two parent tables appear grayed out and are not selectable, even though they are all connected in the same way, using the employee name as a lookup field.

As shown in the screenshot, only the first table’s name field is selectable, while the others are disabled.

What might be causing this behavior, and how can I make all three lookup fields usable in the form?

Thank you!

  • The first thing to check is that in the two relationships with the problem, to go to the field properties for [related employee], and be sure it has its proxy field set as Employee Name.  

3 Replies

  • The first thing to check is that in the two relationships with the problem, to go to the field properties for [related employee], and be sure it has its proxy field set as Employee Name.  

    • MeaganMcOlin's avatar
      MeaganMcOlin
      Qrew Cadet

      Mark, that worked! I had been looking at this for so long that my brain wouldn't even process anything anymore, lol. Thank you so much!

      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

         I always say that most of Quickbase isn't difficult, but you have to trip over 1,000 easy things once to learn them.