I think you want: subset=db(db.person.id<=100) db.dog.owner.requires = IS_IN_DB(subset, 'person.id', '%(name)s')
the value of _and is used in validation but ignored when building the dropdown On Aug 26, 12:55 am, Noel Villamor <noe...@gmail.com> wrote: > From the manual: > > subset=db(db.person.id>100) > db.dog.owner.requires = IS_IN_DB(db, 'person.id', '%(name)s', > > _and=IS_NOT_IN_DB(subset,'person.id')) > > Am I right in my interpretation that the dog.owner dropdown will only > show person names who are not in the subset? > > Am trying to implement '_and' but it seems to be not working as I > expected. Is this because the subset validation is not a filter > function but rather as merely a check upon form submit?