Hi,
I don`t know why you are referencing another table, but if this is only for
populate that field and you know that those values will not change or
increase, you may consider using lists:
METALS = (
(1, 'silver'),
(2, 'gold'),
(3, 'iron'),
(4, 'zinc')
)
db.table.field1.requires = IS_IN_SET(METALS, zero=None)
this should solve your problem and create a select for you, also you will
not need to confirm selection.
Em segunda-feira, 17 de junho de 2013 13h48min05s UTC-3, webpypy escreveu:
>
> Thank you, everybody.
>
> let me describe what i am trying to do.
>
> a table has field1 , field2
>
> field1 is referenced in reftable1
> field2 is referenced in reftable2
>
> reftable2 has a field (reftable1_id) that is referenced in reftable1.
>
> field1 is entered through dropdown list by
> db.table.field1.requires = IS_IN_DB(db(db.reftable1.id>0),'reftable1.id'
> , '%(name)s')
>
>
> My question is about entering field2, the dropdown list needs to be
> according to the value entered in field1.
> db.table.field2.requires = IS_IN_DB(db(db.reftable2.reftable1_id ==
> request.vars.field1),'reftable2.id','%(name)s')
>
> is not working.
>
>
> why?
> or how to debug?
>
> Regards,
>
> ashraf
>
>
--
---
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
