Help SQL Forum Development in ASP

Hi All,

Hopefully you can help me with this one, i've read lots of articles about building forums using access, and i'm aware that there are lots of plugins available. however as my user table is already on the server i would like gto try and build my own forum.

The area that i'm struggling with is, showing either the number of topics in the forum or the number of responces to each topic on a forum / topic overview page.

I have three tables on my server -

Forums.dbo which includes ForumID(PK), ClientID, ForumTitle etc
Topics.dbo which includes TopicID(PK), ForumID, ClientID, TopicTitle etc
Responce.dbo which includes ResponceID(PK), TopicID, ForumID, ClientID, ResponceTitle etc

So far I've managed to build a page that displays a list of forums, using a recordset and a repeat region, this is basically just a repeated region of Forum Titles. Now what i'm trying to do is include a column that highlights the number of topics in each form, so that rather than just being displayed the forum title, our users can see how many topics have been posted before clicking.

This unfortunatly is where i seem to be hitting a brick wall, so would be grateful for advice on how to do this -

Thanks in advance -