This all looks promising. Meanwhile, here's my model with irrelevant Fields omitted and below that my query for the Select. Thanks for the help!
A simplified version of my model: db.define_table('movie', Field('title','string'), db.define_table('person', Field('name', 'string', unique=True), db.define_table('star', Field('movie_id', db.movie), Field('person_id', db.person), movies_and_stars = db((db.movie.id == db.star.movie_id) & (db.star.person_id == db.person.id)) On Tuesday, August 14, 2012 2:16:56 AM UTC-4, rochacbruno wrote: > > I guess you can also do: > > table = TABLE(*[TR(TD(movie.title), TD(UL(*[LI(star.name) for star in * > movie.stars.select()*])) for movie in movies]) > > when a table is referenced by another, he gets a "DAL Set" object with the > referer name. > > movie.*stars *will be a DAL Set. which has *select, update, delete*methods > > But it will only happens depending on your model and relations definition. > > Can you share your model for those 2 tables? > > > On Tue, Aug 14, 2012 at 3:10 AM, Bruno Rocha <rocha...@gmail.com<javascript:> > > wrote: > >> Foreach movie in movies >> print movie.title >> foreach stars in movie.stars >> print star.name >> > > --