We sell different lines of software to customers so we have a field called Product_Interest. However, i'm having difficulty dealing with these two criteria for setting up the field.
1. The data appends instead of overwriting (Product A, Product B...etc)
2. If the same data exists, it doesn't append(Product A for product interest and if they bought it again the field would remain (product A) instead of (Product A, Product A).