Hierarchy Data Model query!
We have a scenario in which we have to model data hierarchy data as
leaf node Field1;Field2;Field3
Here we have the values for the above fields say
Field1 : 100
Field2 : ABC
Field3 : XYZ, asd, qwe, rty
So we are trying to provide 100:ABC;XYZ
100;ABC;asd and cont.
When I try to make the 3 field unique, system is not allowing me to create the second row as it is giving unique key contraint violated, so how can I make the combination of three fields unique.
One answer to model this can be to use Taxonomy table with attributes as field3, but somehow ( data is large), we want to avoid that.
so please help me on this.
Hope I make the requirement clear.