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!