These r my tables
Tab A
``````
A_catid
1
2
Tab B (child of A)
``````
B_catid A_catid
1 1
2 1
3 1
4 1
5 2
6 2
Tab C (child of B)
`````
C_rowid B_catid
1 1
2 1
3 1
4 2
If user selects an item from Tab_A I want that the corresponding rows from Tab_B be displayed along with the count of child rows
that each record of Tab_B has in Tab_C
In this case when user selects 1 from Tab_A
the output should be given as follows:
1 -- 3
2 -- 1
3 -- 0
4 -- 0
HELP !
Tab A
``````
A_catid
1
2
Tab B (child of A)
``````
B_catid A_catid
1 1
2 1
3 1
4 1
5 2
6 2
Tab C (child of B)
`````
C_rowid B_catid
1 1
2 1
3 1
4 2
If user selects an item from Tab_A I want that the corresponding rows from Tab_B be displayed along with the count of child rows
that each record of Tab_B has in Tab_C
In this case when user selects 1 from Tab_A
the output should be given as follows:
1 -- 3
2 -- 1
3 -- 0
4 -- 0
HELP !