many-to-many database relationship

[Tiger99]

I am trying to develop an application which has a many-to-many database relationship like the following.

User Table
userid
user name
user info

User_Cds Table
user_cds id
userid
cd id

Cd Table
cd id
cd title
cd file

This is my first time developing an application with these kind of table relationship. I am not sure how the layout of my application should be to achieve the purpose to the relationship.

Can some one please help me out

Thanks in advance

[mrhatch]

It looks perfectly okay. I would drop the "user_cds_id", because you don't really need that as a prim.-key.
Your SQL-Statement would look as follows:
SELECT * FROM tblusers, tblusercds, tblcds WHERE userid=usercdid AND cdid=usercdid;

That's it.