Columns that reference sys_choice can be created, but break when the list is edited.
Steps to Reproduce
- Navigate to Tables or to Dictionary
- Create a column of type reference with the referenced table being sys_choice
- Observe the column is created but it will not allow to be edited
Reference columns on sys_choice are not supported. This is because when a sys_choice entry changes, the entire list for that table.element are regenerated, and all of the choices get new sys_ids. Any columns that reference sys_choice need to be re-implemented so as not to point to the sys_choice table.
The unexpected behaviour when trying to edit was addressed in Jakarta by a UI Policy warning the administrator that Choice[sys_choice] is not a valid reference field target on a Dictionary form of a Reference field referencing the Choice table.
Related Problem: PRB713817