Do I use Hierarchy or Hierarchy belongs to?

[Anonymous]

Hi all,

I have this:

Grandmother	Mother	Daughter
1	3	8
1	4	9
1	5	10
2	6	11
2	7	12
-	13	14

and I want:

Grandmother	Mother	Daughter	Link field
1	3	8	8
1	4	9	9
1	5	10	10
2	6	11	11
2	7	12	12
-	13	14	14
1	3		3
1	4		4
1	5		5
2	6		6
2	7		7
	13		13
1			1
2			2

I hope you can help!

Best regards,

Arjan

[martijn · Accepted solution]

LinkFieldTable:

Load

Grandmother as LinkField,

Resident Table

Concatenate load

Mother as LinkField

Resident table

Concatenate load

Daughter as LinkField

resident table