If you create an application and make four different fields and make them all required by one of the following ways when you attempt to submit the form they all show as being required in different ways. 1. In data design ( Set the field as required in the Table design ) 2. Field override in Composer on the transition
drop index SLS_CATEGORY_UI_1 on SLS_CATEGORY; alter table SLS_CATEGORY alter column lower_name nvarchar(256) collate Latin1_General_100_BIN not null; create unique index SLS_CATEGORY_UI_1 on SLS_CATEGORY(lower_name);