I have a list with 3 columns that are currently relevant:
Customer Code | Product Line | Part Number
I want to enforce unique values across all 3, so that at least one value of the three columns needs to be different.
If this were an excel spreadsheet, this would be easy to solve using the concatenate function. However, calculated columns in SharePoint cannot be used for validations in that same way it seems.
-Customer Code is a lookup column (not sure if that matters here)
-This will primarily be used in data sheet view, with users pasting in many rows of data from an excel sheet
I've read that event receivers could help to solve this, but I do not currently have access to Visual Studio 2010. Any alternative solutions/workarounds are much appreciated!