Maybe it's a subtle "bug" that comes from nowhere, but in my installations the Table settings -> Field setting of a Defined choice does not work as expected.
Both the suggested rules:
do not work. Another option is a better substitute for this one, the Values defined by table, which works very well.
As a workaround (or a better solution) for multiple choices which do not deserve a table by themselves, a table like the following could be used.
CREATE TABLE common_options (
cod varchar(10) primary key,
label varchar(60) unique,
where usage contains the categories or domains of the choices.
Log in to post a comment.