Hi
I am making a commercial forum for a client and have run against some problems.
I have designed the database for it so that the user can have as many areas in the forum as they want, and am coming against problems with repeat regions in DWMX with the total amount of posts for that area.
On the list of areas I have some details about each area, and a column displaying the number of posts in that area. The problem im running into comes with the repeat region that shows all the areas in a forum. Recordset A is what powers the repeat region, and displays the area nformation, and the total number of posts is fed by recordset B. The posts are stored in the same database as the list of areas, both are in different tables.
When tested in Internet Explorer, the total number of reples is always 1 for all areas, instead of displaying the true amount of posts for that area. I have a feeling it may be to do with the fact that Recordset A is what feeds the Repeat Region (and displays most info apart from total replies) and Recordset B feeds the Total Number of posts.
Any suggestions, I have less than 48 HOURS TO THE DEADLINE, PLS HELP!!!!