I have a need to create a SharePoint list containing two or more synchronized, multi-value columns. For example, let's say that I have a list of medicines and want to specify all of the active and inactive ingredients, along with their corresponding strengths. The data should look something like the following:
Product Column: Product X Ingredient Name Column: Ingredient 1, Ingredient 2, Ingredient 3 Ingredient Strength Column: 5mg, 10mg, 20mg Ingredient Type Column: Active, Inactive, Inactive
Essentially, I am trying to capture that fact that Product X contains the following 3 ingredients:
Ingredient 1 / 5mg / Active Ingredient 2 / 10mg / Inactive Ingredient 3 / 20mg / Inactive
I would like to create three multi-value columns (Name, Strength and Type), but enable the user to specify values in a synchronized way. This would ensure that the first value in each of the three multi-value columns pertain to the same product. The same would hold true for subsequent ingredients.
Does anyone know how I can do this in SharePoint? Any advice you can provide would be greatly appreciated.
Thanks a lot!