Hello, I have a situation were I need to use a referenced field from the referenced table...
I have table a that is referenced by table b, so there is a_id FK field in table b. But now I want table c to reference table b but to discriminate record I need the representation of a id in the dropbox of c form because b table are meaning less with a id represent. It occurs that IS_IN_DB does not let you access the value of the referenced table, I mean I can't do something like this : IS_IN_DB(db, 'b.id', represent_dict[a_id] + b.other_field) I thought about using IS_IN_SET and constructing my own key / value there but IS_IN_SET don't allow you to pass a dict instead of list, as far as I know. If I could pass a dict, IS_IN_SET could display the representation of the records of my referenced table but pass the id of this record to form.vars.reference_field instead of the text of the represent. I must need a custom validator... But I think that a more advanced IS_IN_SET could be welcome in this kind of situation... Thanks Richard -- --- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
