Skip to main content
Question

Related field in Grid edit Changes after 1000 from drop down to record picker

We have an app that we built to manage two bin  inventory system and allows a user to scan a bar code on a physical Kan Ban Card .  We scan a part number ie(100-2300) into a grid edit report.  The field we scan is a related table look up field.   It worked great until we got over 1000 records and then the drop down list changed to a Browse for an item look up..  This has dramatically slowed down our process.   Is there anyway to over ride it back to a drop down list?  
Thank you!

------------------------------
jonathan duke
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    To my knowledge there is no way to force a drop down if over 1,000 choices. 


    But if you make it a conditional drop down to get the list under 1,000 then it will work. Can you have the user enter say the first digit of the bar code manually?  Or some other entry which would allow a CDD to result in under 1,000 records. 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement