Invalid value in select box
Posted: Sat Jan 09, 2021 4:14 am
I have a question regarding select boxes.
We use lots of select boxes and the other day I had a problem we were not aware of.
We have select boxes for transport methods that are used in several screens.
Now somebody deleted a transport method that was used in a sales order - don't tell me we should use relational constrains, nobody uses relational constrains for every foreign key :)
Since the record in the list of transport methods has been deleted the select box appears to be empty although the key is populated with the value in the sales order. However, since there is no matching record in the table with the transport methods the user cannot see the key nor will he notice that the transport method has become invalid.
Any idea, anybody?
Perhaps (future release) select boxes should show a text like '?????' or "invalid", ... in such a case.
Best wishes
Rainer aus dem Spring
We use lots of select boxes and the other day I had a problem we were not aware of.
We have select boxes for transport methods that are used in several screens.
Now somebody deleted a transport method that was used in a sales order - don't tell me we should use relational constrains, nobody uses relational constrains for every foreign key :)
Since the record in the list of transport methods has been deleted the select box appears to be empty although the key is populated with the value in the sales order. However, since there is no matching record in the table with the transport methods the user cannot see the key nor will he notice that the transport method has become invalid.
Any idea, anybody?
Perhaps (future release) select boxes should show a text like '?????' or "invalid", ... in such a case.
Best wishes
Rainer aus dem Spring