Forum Discussion
SystemAdmin4
Qrew Member
Thanks Blake
I went with the multi-select with values drawn from a separate table for a whole host of reasons.
It is without doubt the most elegant and easy to understand solution for a user when adding and editing records in the primary table - for them to simply select options from the drop down, in what is essentially a many to many relationship.
But I agree my quest to make it easy for the user, has created no end of other problems!
Anyway, many thanks for your input on this - however my current feeling is that my best option is to sacrifice the UI usability benefits of the multi select field, and revert to a relationship based model.
D
------------------------------
dmlaycock2000 dmlaycock2000
------------------------------
I went with the multi-select with values drawn from a separate table for a whole host of reasons.
It is without doubt the most elegant and easy to understand solution for a user when adding and editing records in the primary table - for them to simply select options from the drop down, in what is essentially a many to many relationship.
But I agree my quest to make it easy for the user, has created no end of other problems!
Anyway, many thanks for your input on this - however my current feeling is that my best option is to sacrifice the UI usability benefits of the multi select field, and revert to a relationship based model.
D
------------------------------
dmlaycock2000 dmlaycock2000
------------------------------
BlakeHarrison
4 years agoQrew Captain
Maybe there was a bit of confusion on both sides, but the relationship model was what I was suggesting. The original setup of a Multi-select text with choices based on another field is admittedly easier for the user, but is not scalable.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------