Query For Linking Activity
I need your help in writing a query. My Scenario is as follows:
I add an Activity whose Code is 95. Now using activity no. 95, I make a follow-up whose no. is 103. Now using 103, I create another follow-up, no. is 110. And using 110 I create my last follow-up, no. is 118.
Now if user selects activity no. 118 & want to see the history or previous conversation made against this activity then he/she should get 110,103 & 95
And if user selects activity no. 95 & want to see the history or conversation made against this activity then he/she should get 103, 110 & 118.
Please help me in writing this query.
Any kind of help would be appreciated.
Thanks & Regards