Lookup field not showing in dropdown

Question

I have two drop down fields in a form that are pulling data from the same table. They seem to be working for most of the values in the table. However, I had a user enter a support ticket stating one customer and corresponding customer identifier do not appear in the dropdowns. I verified the data is in the source table, but it still is not showing in the dropdowns in the child table. This is the first time I have encountered a situation where some data is coming through and other data is not and am not sure where to look.

------------------------------
Paul Peterson
------------------------------

markshnier__you · Answer

There are two immediate possibilities. The first that the form may be specifying a certain report to use for the drop-down and that report may have a filter on it. For example only dropping down customers flagged as active or something like that. The other less probable possibility is that there are permission issues which are preventing users from seeing certain customers.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

paulpeterson1 · Answer

I am not using any filters in the dropdown or in the table. Also, if it was a permission issue, wouldn't it block all of the names and ids?

------------------------------
Paul Peterson
------------------------------

markshnier__you · Answer

Can you try looking carefully at which fields are being used in the drop-down report and then for the missing customer confirmed that customer has a value in that field?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

paulpeterson1 · Answer

Sorry, looking like a case of Rectal Cranial Inversion.&nbsp; There are two similar tables and I was looking in the wrong one.&nbsp; Problem solved------------------------------Paul Peterson------------------------------

Forum Discussion

Lookup field not showing in dropdown