I have a cyclic table having parent child relation in the same table.
The snap shot of this table is :
m_id p_id d_id name
*1 0 5 usb hub
1 0 6 sd card
*1 5 7 power cord
2 0 1 brush
2 0 2 straw
3 0 1 fork
*4 0 7 digi cam
*4 7 8 flash card
and so on
The report displays data as grouped with m_id.
Further requirement is what I am not able to achieve. The requirement states that: The names of the items should be clubbed together for those records which have p_id = d_id
That means as per above table: the highlighted table data needs to be clubbed within the major group m_id
So the report for m_id should show:
Expected Result:
m_id name
1 usb hub, power cord
1 sd card
4 digi cam, flash card.
and so on....
Kindly provide feedback,
Awaiting reply
Thanks
Ajay G
The snap shot of this table is :
m_id p_id d_id name
*1 0 5 usb hub
1 0 6 sd card
*1 5 7 power cord
2 0 1 brush
2 0 2 straw
3 0 1 fork
*4 0 7 digi cam
*4 7 8 flash card
and so on
The report displays data as grouped with m_id.
Further requirement is what I am not able to achieve. The requirement states that: The names of the items should be clubbed together for those records which have p_id = d_id
That means as per above table: the highlighted table data needs to be clubbed within the major group m_id
So the report for m_id should show:
Expected Result:
m_id name
1 usb hub, power cord
1 sd card
4 digi cam, flash card.
and so on....
Kindly provide feedback,
Awaiting reply
Thanks
Ajay G