Forum Discussion

KaitlynStanley's avatar
KaitlynStanley
Qrew Trainee
2 years ago

Multiple Choice From Another Field Help

I am running into an issue with using shared values from one field to another. I have a field on App One, Table A, called, Facility. It's Text - Multiple Choice. It uses From List to display the o...
Relationships
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
in my experience, when you use values from a other field, it will present the unique choices in the data, as opposed to the choices in the multiple choice field itself.  Can you add an occurrence of the missing data choice as a record in Table A and see if that solves the problem.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
KaitlynStanley's avatar
KaitlynStanley
Qrew Trainee
2 years ago
I did go ahead and add the missing choice to a record and it does solve the problem. I just wasn't sure if there was a way around it. So that all choices are shown whether it's used in the data or not.

------------------------------
Kaitlyn Stanley
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    2 years ago
    No, that's how it works. You might also making a proper table of the choices, making the text field for the choice the Key Field and then making a relationship to pull the choices.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------