hi
i have 2 really simple data models
data set 1
Code
1
2
3
data set 2
TopLevel desc
1 apple
2 banana
3 Carrot
i join the 2 table with a relationship Code = Toplevel, i have no duplicates
but when i use a pivot table to show the data i get
Code Desc
1 apple
banana
Carrot
2 apple
Banana
Carrot
im obviously missing something obvious to a trained eye?
any ideas?
mal
i have 2 really simple data models
data set 1
Code
1
2
3
data set 2
TopLevel desc
1 apple
2 banana
3 Carrot
i join the 2 table with a relationship Code = Toplevel, i have no duplicates
but when i use a pivot table to show the data i get
Code Desc
1 apple
banana
Carrot
2 apple
Banana
Carrot
im obviously missing something obvious to a trained eye?
any ideas?
mal