Bear with me my language is not english, so ill try to be plain and
straight
i have a table that references another 2 tables.
when im generating the form works nicely as i want, but when i
retrieve the list with a db select all i dont get the referenced names
of the tables...i get only the id's...how should i do it to get the
names ('nome')? thanks.
im thinking about a join, but cant seem to do it....
db.define_table('edificios',
Field('nome'),
Field('morada'))
db.define_table('tipoavaria',
Field('nome'))
db.define_table('avariasdb',
Field('user', db.auth_user, default=auth.user_id,
writable=False,readable=False),
Field('edificio', db.edificios),
Field('piso'),
Field('tipo', db.tipoavaria),
Field('descricao', 'string', widget=SQLFORM.widgets.text.widget),
Field('data', 'datetime', default=request.now, writable=False))
db.avariasdb.edificio.requires = IS_IN_DB(db, 'edificios.id',
'edificios.nome', zero=T('Choose One'))
db.avariasdb.tipo.requires = IS_IN_DB(db, 'tipoavaria.id',
'tipoavaria.nome', zero=T('Choose One'))
