a little bit of wording around "unfortunately I can't turn off...."
it's not that having constraints in place is limiting your app. It's because something REAALLY wrong with your application that that error pops up (and it'll pop up with any other backend). I'd be more inclined to say "thanks a lot web2py, I can't turn it off, or else, I'm going to be really screwed once I put this on production". Back on topic.... Field('email_id', db.auth_user,length=512, label = 'Email ID') this is a FK to the field *id* of the table *auth_user*. length doesn't obviously go there (as it's an integer) and the validation you're imposing is totally wrong........ db.nsksystem.email_id.requires = IS_IN_DB(db,'auth_user.email','%(email)s') Are you sure you planned your model the way you're supposed to use it ? IMHO you're expecting that field to contain an email, not an id. -- 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.