Is there a reason why you are not using Auth, if you aren't? http://www.web2py.com/book/default/chapter/08#Authentication
Anyway, assuming that you truly want to add the unique constraint, then I am guessing that you could construct virtual fields http://www.web2py.com/book/default/chapter/06#Virtual-Fields and apply the constraint http://www.web2py.com/book/default/docstring/IS_NOT_IN_DB db.page.title.requires = IS_NOT_IN_DB(db, 'page.title') #http:// www.web2py.com/book/default/chapter/03 On Dec 29, 2:47 am, ron_m <ron.mco...@gmail.com> wrote: > I would like to respectfully ask how a first and last name combined could be > unique in the real world? There are lots of people with identical first and > last names. > > A better candidate in your table is Email. > > I know that doesn't answer your question but I think it is worth > consieration. > > Ron