I should have mentioned that I tried IS_IN_DB first off and it didn't work On Wednesday, February 10, 2016 at 4:25:48 PM UTC-7, Dave S wrote: > > > > On Wednesday, February 10, 2016 at 2:01:52 PM UTC-8, Greg White wrote: >> >> Want a computed field to show whether or not a field value exists in >> another table >> > > > I'm not sure that is the right approach. I think that the standard > validator IS_IN_DB() is what you want, instead. > > <URL: > http://web2py.com/books/default/chapter/29/07/forms-and-validators#Database-validators > > > (IS_IN_DB is the second validator in that section) > > The example shown appears to be similar to what I think you're trying to > do. > > /dps > > >> started with this... >> >> db.define_table( >> 'inventory', >> Field('name'), >> Field('qty', label='Quantity'), >> Field('MatSize',label='Material Size'), >> format = '%(name)s') >> >> db.define_table( >> 'POrequest', >> Field('name', 'reference requestor', label='Requestor'), >> Field('JobNum', 'reference jobs', label='Job #'), >> Field('description', 'text', notnull=True), >> Field('InInventory', compute=lambda r: r['description'] IN r[ >> db.inventory.name]), <<< this row right here is what I need help with >> format = '%(name)s') >> >> trying to verify row by row in a computed field if >> db.POrequest.description is in any row of db.inventory.name >> >> help please. >> >
-- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.
