Forum Discussion

RoyKiesling's avatar
RoyKiesling
Qrew Trainee
7 years ago

Multiple choice field with choices from shared field - wrong choices

I have a multiple choice field in one table that shares the selection options from a field in a different table. Instead of pulling from the typed in list of possible selections, it pulls from the fie...
Forms
Tables and fields
RoyKiesling's avatar
RoyKiesling
Qrew Trainee
7 years ago
I am not  sure you are understanding my issue: the source field is already a multiple choice field with a list of choices.  The second field does not pick up the list of choices I typed in; instead it picks up actual values from the first field data.  
Laura_Thacker's avatar
Laura_Thacker
Qrew Commander
7 years ago
This problem is the primary reasons why 99% of the time I do not recommend this type of field-reference option.  However, recently I used a "use from list" option when I had 3 fields of the same multi-select options needing to have the same options.  I point them all to a "source table" of records where the key field in that table is the option.  This way we maintain the list in one place and can use it reliably in 3 other places.
  • SonglorXiong's avatar
    SonglorXiong
    Qrew Member
    6 years ago
    Laura,

    I have a need for this.  Could you stretch little bit to tell how you go about doing it?  I'm new to Quick Base.  Thanks.

    ------------------------------
    Songlor Xiong
    ------------------------------