Hierarchy Data Model query!

[former_member198938]

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.

[Former Member]

havent understood ur requirement !

[former_member198938]

I want my leaf Node to have values like this

100,XYZ,ABC

100,XYZ,DEF

100,XYZ,GHI

100,XYZ,JKL

100,XYZ,MNO

all these fields are Display fields,also I thought of making them as Unique since the combination of the three is unique.

But after that also I am not able to assign these values to the Node as it is violating Unique key constraint.

Is there any way I can make the combination unique.

[Former Member]

there can be only 1 unique display field in the hierarchy table - so the combination stuff is ruled out

if you have just the values to be displayed : (no need of field names) - then all you can do is to have the values appended by delimiter comma and then assign to 1 display field.

else if you need field names and then their respective values - use taxonomy with attributes.

hth

thanks

-Adrivit