I am looking to add in a field that is a multi-select using a long list of long values.
I have tried two approaches, both with are insufficient.
- By using a normal multi-select field, I get the errors that I can't have more than 50 choices, and none longer than 40 characters each
- I added the list to a new table and added a relationship so you could select the appropriate value, however I can't figure out how to make this multi-select. This approach had the benefit of being able to have a conditional drop-down, based on three categories, to limit the options.
Is there a way to make either of these work?