How can a user search from a list of records?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a table to table relationship. One vendor has many orders. When the user chooses from the drop down field of "Related vendors" on the Orders table, I would like them to be able to search for the vendor rather than scrolling down the huge list. I know this is possible because I have done it before but I cant remember how!

Thank you!

Photo of Amanda

Amanda

  • 10 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,168 Points 50k badge 2x thumb
On the FIELD properties (FIELD props not Form)  for Related Vendor, check the box that says to use the Record Picker.

The Record Picker, which is that search pop up box, gets used if the drop down list is over 1,000 records or if you check that box it will always get used.