Skip to Content
0
Jun 01, 2011 at 01:19 PM

Hierarchy Data Model query!

32 Views

Dear Experts,

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.