Forum Discussion
MarkShnier__You
Qrew Champion
Ok, Those screenshots help me understand your question.
I had assumed from your question that you were referring to what is called a multi select field this is a field type where you can select multiple selections. In fact you have what is called a multiple choice field.
The main stream solution to this is that you should have a table of your choices. There would be columns in that choices table for the ABC and another column for the explanation. Then you would make a Relationship where one choice has many of our detail records.
You can then use the advanced settings for that table to set what is called the record picker fields, these are the fields which will be shown to the user when they go to pick records and through the relationship you can look up the A C C D choice and the detailed description down to your detail record and show it on the form.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
I had assumed from your question that you were referring to what is called a multi select field this is a field type where you can select multiple selections. In fact you have what is called a multiple choice field.
The main stream solution to this is that you should have a table of your choices. There would be columns in that choices table for the ABC and another column for the explanation. Then you would make a Relationship where one choice has many of our detail records.
You can then use the advanced settings for that table to set what is called the record picker fields, these are the fields which will be shown to the user when they go to pick records and through the relationship you can look up the A C C D choice and the detailed description down to your detail record and show it on the form.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
PatrickO_Neill
2 years agoQrew Member
Thanks Mark
------------------------------
Patrick O'Neill
------------------------------
------------------------------
Patrick O'Neill
------------------------------