I have been asked to add another key value into UD110/110A so the records become more unique. I want to put the word “TEST” into key5. I have a BPM set up to put it in when I create a new UD110 record, but how do I DMT that value into existing records? I get record not found when I try to do an update.
Do an Add New and then a delete. One to insert all the new records for UD110/110A along with the childkeys and then one to remove the old records. Then whatever BAQs or reports etc you will need to update the relationships with the new key if applicable.
1 Like
Right, it’s a key, so you can’t change it later.
You are thinking of Key5 as “empty” right now, but it’s not - it has a value of [empty string]. To “fill it in” with a value is to change its value, and that violates database integrity.
2 Likes