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

Question

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

markshnier__you · Answer

To my knowledge there is no way to force a drop down if over 1,000 choices.&nbsp;
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? &nbsp;Or some other entry which would allow a CDD to result in under 1,000 records.&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

jonathanduke · Answer

Thanks for the quick reply. That's a great idea.&nbsp; I'm going to work on that solution and see if I can make it work.Thanks!------------------------------jonathan duke------------------------------

Forum Discussion

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

2 Replies