Qrew Legend... so the issue I believe is that you are sort of taking the expedient way out to use a table as a source for a multiple choice field. You should ensure that the key field of that source table is set to the be the field which holds the text values of the choices, and then make a "proper relationshi"p where One source table record has many "other table" records. When you make the relationship do not Quickbase make a new field - instead select the drop down choice for your current multiple choice field. The Multiple choice field will turn into the Reference field for the child side of the relationship.
Then you can make your perfect report to sort properly (you may need to add a sort field on the parent choices table, and this perfect report can also be filtered, as in other use cases you may want to only offer Active record as choices.
Then go back to your details records table and on the form where the choices field is, set the form to use your perfect report to drive the drop down list.
