Forum Discussion

PaulEaston's avatar
PaulEaston
Qrew Assistant Captain
5 years ago

Multiselect list some options grayed out and italicized

I'm sure I'm missing something obvious, but I'm stuck.  I have a "Cases" table. Many other tables/forms pull from/reference this table using either one-to-many or many-to-many relationships.  I ...
Tables and fields
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago
I'm not certain I understand. You said that you're using relationships to reference these records, but then you also mention having them in a Multi-select field, which isn't possible with a relationship. Can you provide a little more explanation about the structure of your app?

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
PaulEaston's avatar
PaulEaston
Qrew Assistant Captain
5 years ago
For example, I have a Source Registration table. The "Primary Related Cases" is a "Multi-select text" field type. 

Under table-to-table relationships each source has many cases. 

The field's "Multi-select Text field options" as "Input type" set to "From another field" with the "Case name" field from the "Cases" table selected. 

When I try to create a new source record and click on the Primary Related Cases field, three recent cases that I created are grayed out and italicized. I've been adding cases and linking them to Sources for well over a year without running into this issue. But I cannot think of anything I've done differently this time around. 

Yet, I have another table ("Intake") with a "Case Name" field from which only one case may be selected. And the cases are NOT grayed out nor italicized. 
Many intakes below to one case.
The "Case Name" field for the "Intake" table is a Text(lookup) type. 

Hope that helps narrow things down.

------------------------------
Paul Easton
------------------------------
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    Ok, first, you can't have a Multi-Select Text as the reference field for a Relationship. If you've changed the Field Type from whatever it was to a Multi-select Text, you will probably have to rebuild that relationship because it cannot work in this way. If you've had this relationship setup for over a year, it could not have been setup as a Multi-Select Text, but would have had to be changed.

    To properly setup a Many-to-Many relationship in Quick Base requires 3 tables, not 2. You will have 2 Parent tables and 1 Child table. So, in your situation, you have the Cases table and the Source Registration table. To build a Many to Many with these 2 tables, you would need to add a 3rd table - possibly Case Source table - that would be a child to both Cases and Source Registration.

    Once you've reviewed the app structure and made any necessary changes, update us and let us know if you're still having issues.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------