customizing thread view

We have to run a patient support forum with a structure so that a patient is able to see/access only the thread started by himself and not those by other patients. But the professionals/physicians should be able to see/access all patient threads.

We have built memberships 'patient' and 'professional'. They are non-incrementing.

Any guidance how we can make the above modification would be highly appreciated.

Thank you.
Manish

That would indeed be ideal but people don't like to login to different applications for different reasons. If they are already visiting the forums, they prefer to post on the forums rather than loggin on to another application for giving free advice.

Well what I am looking for is something like this:

While displaying threads
      check if the forum-id is equal to the patient forum id
      If yes
           read the username/id from the cookie
           If the user belongs to group 'Patient'
                    fetch from db threads which were started by this user
                    display threads
            End if
     else
           normal webwiz forum code
     end if

I tried to play with the sql on the forum topics page but I am not good at it so getting an error. Can somebody tell me how to do it right?

This is the code that I changed on the fourm topics page:

--------------------------------------

'Select which topics to get

' ** Begin Patient Forum Mod **

If intForumID=40 and intGroupID=15 then
    strSQLFromWhere = strSQLFromWhere & "AND Topic.Start_Thread_ID = lngLoggedInUserID "
End if

' ** End Patient Forum Mod **



strSQLFromWhere = strSQLFromWhere & "AND (" & strDbTable & "Topic.Priority = 3 " & _
        "OR " & strDbTable & "Topic.Moved_ID = " & intForumID & " " & _
        "OR " & strDbTable & "Topic.Forum_ID = " & intForumID & ") " & _
    ") "

'If this isn't a moderator only display hidden posts if the user posted them
If blnModerator = false AND blnAdmin = false Then
    strSQLFromWhere = strSQLFromWhere & "AND (" & strDbTable & "Topic.Hide = " & strDBFalse & " "
    'Don't display hidden posts if guest
    If intGroupID <> 2 Then strSQLFromWhere = strSQLFromWhere & "OR " & strDbTable & "Thread.Author_ID = " & lngLoggedInUserID
    strSQLFromWhere = strSQLFromWhere & ") "
End If
----------------------------------------

What I am trying to do is -

If the forum is 'patient forum' and the user belongs to group 'Patient' then
    modify the query fetching the topics so that it only fetches the topics where the topic_start_id=the id of the logged in patient
end if

Now I get this error when a patient goes to the patient forum:

Server Error in Forum Application
An error has occurred while executing SQL query on database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_topic_count
File Name:- forum_topics.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
The multi-part identifier "Topic.Start_Thread_ID" could not be bound.

------------------------------------------

I know my sql query is defective. I would appreciate your help in correcting it.

Thank you.