Hi, I'm doing something like that: if auth.user: my_org = db(db.t_org_members.f_org_member == auth.user.id).select(db.t_org_members.f_org_rep) if my_org: for m in my_org: my_org_members = db(db.t_org_members.f_org_rep == m.f_org_rep).select(db.t_org_members.created_by) for member in my_org_members: org_member_data = db(db.auth_user.id == member.created_by).select(db.auth_user.phone_num, db.auth_user.car_num_0, db.auth_user.email, db.auth_user.profile_image,db.auth_user.first_name, db.auth_user.last_name )
The only problem is that : while this renders three members as expected: {{=my_org_members}} This renders the last member's data only: {{for member in org_member_data:}} <option value="car_">{{=member}}</option> {{pass}} Thanks. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.