Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
3 years ago

Lookup field not showing in dropdown

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
------------------------------

4 Replies

  • 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's avatar
      PaulPeterson1
      Qrew Assistant Captain
      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's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        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
        ------------------------------