Forums
This topic is locked
Display RecordCount of second recordset
Posted 18 Feb 2002 01:00:39
1
has voted
18 Feb 2002 01:00:39 Martin Mitterer posted:
I work with UD4 and PHAkt. Now my problem:I have one recordset with a repeat region that displays news categories from a mysql-table named "category". I would like to count the news of each category to display them near the category, e.g.:
Actuality (5)
Politic (9)
...
The news are in a second table called "news". There is a field "CategoryID" in both tables. Until now I haven't found a solution to get this work. Hope, someone can help me.
Thank you.