Hi,
Our requirement is to store the choice value selections from Multiple dropdown with choices from a record type into a separate join table rather than semi colon separated.
We are using 23.3 version and the application is built on top of record types instead of CDT's and configured the records using many to many relationship between main & join tables. Problem here is the choice value selection neither deleting nor updating in the join table, it's always keep inserting as a new values in the join table every time when we reselect the choice selection.
Is there a way to handle this issue to delete or update the unselected choice selection?.
Discussion posts and replies are publicly visible
If you want to update the same entry, you should use the primary key. Since its mentioned its creating new entry every time, I am assuming primary key is not present. How is the join configured?