Hi Chaps, Please point me in the direction of finder examples for a many to many relationship. Details of what I'm trying to do are below. Thanks, Tim. Table Name: area Columns: id name Table Name: area_area_type Columns: area_id area_type_id Table Name: area_type Columns id description I would like a finder areaHome.findByArea_Type_Id. Do I need to 1. write my own connection to the db and doing a join 2. implement it in a seesion bean doing the direct db conn and join in there and then find by key for each area id found 3. do something magical where CMP does it for me. --------------------- It's not what you know, it's who you tell. ----------------------- "Totalise Email, the most flexible email system in the world. Visit http://mail.totalise.co.uk" -- -------------------------------------------------------------- To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] Problems?: [EMAIL PROTECTED]
