hi thanks for your help but i still get this: friends.id friends.userid friends.hauptperson friends.freund friends.freundseit friends.bestaetigt 9 5 nueva_vido makir 2011-01-04 18:09:46 False 11 5 nueva_vido makir 2011-01-05 23:47:54 False
with: db.friends.freund.requires = IS_NOT_IN_DB(db(db.friends.hauptperson==request.vars.hauptperson),db.friends.freund) and how can i say: db.friends.freund.requires=IS_IN_DB(db,'auth_user.user_name') without the self user name??? thanks so much. peter On 5 Jan., 21:05, DenesL <[email protected]> wrote: > If you want the combination of two fields a,b from table t to be > unique then use: > > db.t.b.requires = IS_NOT_IN_DB(db(db.t.a==request.vars.a),db.t.b)
