master data - 'These columns don't currently have unique values'
-
Hi, I am working on this master data repeater and got almost everything working, i have 3 levels of categories that show correct i believe the problem is on the data that i provide through stored ptocedures then i have the items under the first level almost fine, they are showing fine under their first level category, but the second and third go all under the first instead of group nicelly under their second like
correct: how it is: 1. 1. 1.1 1.1 2. 2.1 2.1 3.2 3. 2. 3.1 3.here it is how the relation goes:DataRelation relation1 = new DataRelation("STOCK_CAT_1", ds.Tables["Cat1"].Columns["STOCK_CAT_ID"], ds.Tables["Items"].Columns["CAT_LEVEL_1"]); ds.Relations.Add(relation1); DataRelation relation2 = new DataRelation("STOCK_CAT_2", ds.Tables["Cat1"].Columns["LEVEL1"], ds.Tables["Items"].Columns["CAT_LEVEL_2"], false); ds.Relations.Add(relation2); DataRelation relation3 = new DataRelation("STOCK_CAT_3", ds.Tables["Cat1"].Columns["LEVEL2"], ds.Tables["Items"].Columns["CAT_LEVEL_3"], false); ds.Relations.Add(relation3); DataRelation relation4 = new DataRelation("CAT_1toCAT2", ds.Tables["Cat1"].Columns["STOCK_CAT_ID"], ds.Tables["Cat1"].Columns["LEVEL1"]); ds.Relations.Add(relation4); DataRelation relation5 = new DataRelation("CAT_2toCAT3", ds.Tables["Cat1"].Columns["STOCK_CAT_ID"], ds.Tables["Cat1"].Columns["LEVEL2"]); ds.Relations.Add(relation5);then when i remove the false from ["CAT_LEVEL_3"], false); to create a relation, ig throws a "These columns don't currently have unique values" here is the data, can anyone spot what is wrong?:Items
Items
Items
Cat1
Cat1
Cat1
CAT_LEVEL_1
CAT_LEVEL_2
CAT_LEVEL_3
STOCK_CAT_ID
Leve1
-
Hi, I am working on this master data repeater and got almost everything working, i have 3 levels of categories that show correct i believe the problem is on the data that i provide through stored ptocedures then i have the items under the first level almost fine, they are showing fine under their first level category, but the second and third go all under the first instead of group nicelly under their second like
correct: how it is: 1. 1. 1.1 1.1 2. 2.1 2.1 3.2 3. 2. 3.1 3.here it is how the relation goes:DataRelation relation1 = new DataRelation("STOCK_CAT_1", ds.Tables["Cat1"].Columns["STOCK_CAT_ID"], ds.Tables["Items"].Columns["CAT_LEVEL_1"]); ds.Relations.Add(relation1); DataRelation relation2 = new DataRelation("STOCK_CAT_2", ds.Tables["Cat1"].Columns["LEVEL1"], ds.Tables["Items"].Columns["CAT_LEVEL_2"], false); ds.Relations.Add(relation2); DataRelation relation3 = new DataRelation("STOCK_CAT_3", ds.Tables["Cat1"].Columns["LEVEL2"], ds.Tables["Items"].Columns["CAT_LEVEL_3"], false); ds.Relations.Add(relation3); DataRelation relation4 = new DataRelation("CAT_1toCAT2", ds.Tables["Cat1"].Columns["STOCK_CAT_ID"], ds.Tables["Cat1"].Columns["LEVEL1"]); ds.Relations.Add(relation4); DataRelation relation5 = new DataRelation("CAT_2toCAT3", ds.Tables["Cat1"].Columns["STOCK_CAT_ID"], ds.Tables["Cat1"].Columns["LEVEL2"]); ds.Relations.Add(relation5);then when i remove the false from ["CAT_LEVEL_3"], false); to create a relation, ig throws a "These columns don't currently have unique values" here is the data, can anyone spot what is wrong?:Items
Items
Items
Cat1
Cat1
Cat1
CAT_LEVEL_1
CAT_LEVEL_2
CAT_LEVEL_3
STOCK_CAT_ID
Leve1
Did you read the posting guidelines? Did you take note of rule 4: Keep the question as brief as possible. If you have to include code, include the smallest snippet of code you can. Did you even notice the warning before you posted that your message was very long? You must have, because you would have had to acknowledge it. I don't supposed you really cared. That shows a complete disregard and disrespect for other people here.