Hello!
I work hard at this recordset query, but will not find the right syntax. Pls. help!

I've tree tables: idea, idea-description, feedback

I'll create a list of ideas, showing date of inserting the idea, idea-description (I will get it from the table idea-description by the ID that is stored in ideas) ... these would be very easy, but ... some of the ideas have one or more feedbacks stored in the feedback table and I will show the number of feedbacks of each idea at the list.

hope I was able to describe it to be able to understand <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

Thanks a lot for any idea

Guenther Kraibacher