I have the following tables: task, opportunity, and oppty_main With the following relations: * task.opportunity_id->opportunity.id * opportunity.oppty_main_id->oppty_main.id
When updating a task I have a SELECT for the related opportunities: db.task.opportunity_id.requires=IS_NULL_OR( IS_IN_DB(db(db.opportunity.id==db.task.opportunity_id), 'opportunity.id')) The problem is how to get the representation to show the name of the opportunity, which is at oppty_main.name! Something like (doesn't work): db.task.opportunity_id.requires=IS_NULL_OR( IS_IN_DB(db(db.opportunity.id==db.task.opportunity_id), 'opportunity.id', '%(db.task.opportunity_id.oppty_main_id.name)s') Miguel
-- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.