Forum Discussion

JordanBeatty1's avatar
JordanBeatty1
Qrew Captain
9 years ago

Use a drop down menu instead of pop-out record picker

Currently, I am setting up alternate relationships between tables for filtered drop down tables. I join the two tables on record ID, then use a proxy field that is a text look up and use a report I ge...
DevinDevin's avatar
DevinDevin
Qrew Cadet
8 years ago
I am not able to find the "Use a record picker instead of a drop down menu" for the field in my app. In my case, I have a child table that has a form to select the a parent record to relate to. In the child table's field properties, this option does not appear. Am I missing something?
  • DevinDevin's avatar
    DevinDevin
    Qrew Cadet
    8 years ago
    As it turns out, the field in question is setup as a 'lookup' field type. I assume this restricts it from being used as a record picker? If so, is there a way to convert the field type without wrecking the relationships which have already been created?
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Are you looking at the field called something like Related Parent. For this setting?
  • BrianCafferelli's avatar
    BrianCafferelli
    Quickbase Staff
    8 years ago
    Hi Devin, the reference field is what controls the record picker behavior. So, to find "Use a record picker instead of a drop down menu" you can go to the field properties for the reference field within whichever relationship you're working with. On that page, you'll see it under the "Reference field options" heading.
  • DevinDevin's avatar
    DevinDevin
    Qrew Cadet
    8 years ago
    Success, figured it out. Thank you Brian!