When we set Ref Type column, and user select from drop-down list.
Now we set this table (reference table) so that use can add, update and delete, for all the action.
So when the user goes to this column, then guided to drop-down list. On the top of list, “New” appears to guide user to enter new data which is not listed up within the drop down list.
We reminded user to “add” new data by clicking “new” and add to the reference table whatever newly they want so that they can select the same from the subsequent occasion. However, annoyingly, most of users are put data (which is not on the list) “directly” to the blank field on the top.
This end up with yellow triangle error mark on various place and view in the app, as such data is not meeting validation rule although use can enter the data.
Is there any possible protective measures users can only input the data which is on the drop down list when it come to Ref type of column?