You cannot have a join in a validator.
On Apr 30, 9:52 pm, niknok <nikolai...@gmail.com> wrote: > The following validator doesn't work: > > IS_IN_DB(db(db.g_province.id==db.g_municipality.province)\ > ,db.g_municipality.psgc_m\ > ,label='%(g_municipality.name)s > (%(g_province.name)s)') > > I am trying to generate a select option that shows a label consisting of > the g_province.name and g_municipality.name fields. How do I do that? > > Thanks. > /r > Nik