Per the suggestion, I’ve gotten in the habit of using databases in many cases instead of single/multi select fields. However, there are a few pain points with this, mostly on the UI front:
- single/multi select fields can be colour coded and have an icon (though the icon issue I think is already resolved)
- single/multi select fields have a very simple display both in the entity view and on other views, whereas relations confuse users because they show up with database icons and the “>” button which opens the related entity. The action to open the entity confuses new users and causes them to lose their current context.
It would be great if you were able toggle on an option to make relation views appear more like single/multi select fields, including allowing them to show-up on the right hand panel and disabling the open action.