I’m trying to make dashboard that allows users to set the industry class on customers. However whenever they change the industry class it creates a new row instead of changing the existing row. (This is because the ICCode is a key field).
I figured since we only need a customer to be in one industry class I could make a BPM that deletes all other Industry Class from the customer on update. But I can’t seem to get them to delete. I did a trace and deleted on in the customer entry form, and it does it via the Customer.Update method. But its in the “paramDataSetChanges” section:
<paramDataSetChanges>
<paramDataSet name="ds" useDataSetNbr="0">
<deletedRow tableName="CustIC" rowState="Deleted" rowNum="0" />
</paramDataSet>
</paramDataSetChanges>
I tried making a BPM that calls Customer.Update and sets the CustIC rowmod to “D” but its not working and I don’t know why.