@NL66278 So, I have changed this to use codes instead, my problem here again is that the codes are neither unique nor read only. I did advice ari not to change them but can we be sure? There is a unique constraint but only for the combination of code and name, but I cannot base my search on names since they change them (this is what happened this time). Opinions? Should this be implemented on a different way?
@NL66278 So, I have changed this to use codes instead, my problem here again is that the codes are neither unique nor read only. I did advice ari not to change them but can we be sure? There is a unique constraint but only for the combination of code and name, but I cannot base my search on names since they change them (this is what happened this time). Opinions? Should this be implemented on a different way?