Can someone guide me the best way to do add/remove values from multi value fields?

Hi,

I have 6 different categories and each category has different products. There are 10 other fields containing values for these products.

The products will be changed once or twice in a year to different categories and I am capturing these in a config document. Whenever these product categories are changed, I have to run an agent to update all the existing documents in the database.

Ex:

If the existing document says Product “Apple” is in category A and it has changed to Category B. So I have to move all the related values of “Apple” to B Related category fields.

Please let me know how to do this in a better way.

Appreciate your help

Thanks

sri

Subject: Look up @replace and @trim in the domino designer help

Also search this forum for remove and list