I have a parent group and a child group. How do you add a child group to the child group?

parent
	child
		child

• Edited by ForumHelp7 2 hours 43 minutes ago

Rightclick on your childgroup row group >> Add Group >> Child Group

Don't forget to mark helpful posts, and answers. It helps others to find relevant posts to the same question.

It's added to the left column instead of below.

	parentgroup
	child group
child group

Sample data needs to appear like this.

	GRAND DAD
	dad
	mom
	child
	child
	child

• Edited by ForumHelp7 2 hours 12 minutes ago

Can you post your sample dataset ?

CREATE TABLE [dbo].[FAMILY](
	[GP_ID] [int] NULL,
	[P_ID] [int] NULL,
	[C_ID] [int] NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[GRAND_PARENT](
	[ID] [int] NULL,
	[DESCR] [varchar](50) NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[PARENT](
	[ID] [int] NULL,
	[DESCR] [varchar](50) NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[CHILD](
	[ID] [int] NULL,
	[DESCR] [varchar](50) NULL
) ON [PRIMARY]

INSERT INTO [TEST].[dbo].[GRAND_PARENT] VALUES (1,'GrandParent1')
INSERT INTO [TEST].[dbo].[GRAND_PARENT] VALUES (2,'GrandParent2')
INSERT INTO [TEST].[dbo].[GRAND_PARENT] VALUES (3,'GrandParent3')
INSERT INTO [TEST].[dbo].[GRAND_PARENT] VALUES (4,'GrandParent4')
INSERT INTO [TEST].[dbo].[GRAND_PARENT] VALUES (5,'GrandParent5')

INSERT INTO [TEST].[dbo].[PARENT] VALUES (1,'Parent1')
INSERT INTO [TEST].[dbo].[PARENT] VALUES (2,'Parent2')
INSERT INTO [TEST].[dbo].[PARENT] VALUES (3,'Parent3')
INSERT INTO [TEST].[dbo].[PARENT] VALUES (4,'Parent4')
INSERT INTO [TEST].[dbo].[PARENT] VALUES (5,'Parent5')
INSERT INTO [TEST].[dbo].[PARENT] VALUES (6,'Parent6')
INSERT INTO [TEST].[dbo].[PARENT] VALUES (7,'Parent7')
INSERT INTO [TEST].[dbo].[PARENT] VALUES (8,'Parent8')
INSERT INTO [TEST].[dbo].[PARENT] VALUES (9,'Parent9')
INSERT INTO [TEST].[dbo].[PARENT] VALUES (10,'Parent10')

INSERT INTO [TEST].[dbo].[CHILD] VALUES (1,'Child1')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (2,'Child2')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (3,'Child3')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (4,'Child4')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (5,'Child5')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (6,'Child6')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (7,'Child7')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (8,'Child8')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (9,'Child9')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (10,'Child10')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (11,'Child11')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (12,'Child12')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (13,'Child13')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (14,'Child14')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (15,'Child15')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (16,'Child16')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (17,'Child17')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (18,'Child18')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (19,'Child19')
INSERT INTO [TEST].[dbo].[CHILD] VALUES (20,'Child20')

INSERT INTO [TEST].[dbo].[FAMILY] VALUES (1,1,1)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (1,1,2)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (1,2,3)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (1,2,4)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (2,3,5)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (2,3,6)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (2,4,7)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (2,4,8)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (3,5,9)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (3,5,10)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (3,6,11)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (3,6,12)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (4,7,13)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (4,7,14)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (4,8,15)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (4,8,16)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (5,9,17)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (5,9,18)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (5,10,19)
INSERT INTO [TEST].[dbo].[FAMILY] VALUES (5,10,20)

• Edited by ForumHelp7 1 hour 8 minutes ago

So you want this to be done recursively? Also how do you represent cases where child has children in next level? In that case you repeat their information in Parent as well as child tables?