Hi, I got a table scheme which can be shortened to this:
Person: columns: id: { type: integer(4), notnull: true, unique: true, primary: true, autoincrement: true } user_id: { type: integer(20) } name: { type: string(100), notnull: true } contract_id: { type: integer(4) } relations: Contract: { class: Contract, local: contract_id } Contract: columns: id: { type: integer(4), notnull: true, unique: true, primary: true, autoincrement: true } organisation_id: { type: integer(4), notnull: true } code: { type: string(3), notnull: true } Organisation: columns: id: { type: integer(4), notnull: t rue, unique: true, primary: true, autoincrement: true } name: { type: string(100), notnull: true, unique: true } I tried extending the query with an innerJoin: $query = Doctrine::getTable('Person')->createQuery('p')->innerJoin('p.Contract c'); $this->widgetSchema['dhb_area_id']->setOption('query',$query); $this->widgetSchema['dhb_area_id']->setOption('method','getOrganisationId'); --> this leaves the select dropdown with empty strings I was thinking about using table_method, but either way, how do I get around the name conflict, ie. if I use 'getName', how can I choose which table it comes from? Thanks for any help, Jochen -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en