Hello i am new to web2py i create a table in mysql db that need to have 3 unique field:
- ID_USER - ID_GROUP - ID_USER_ORGANIZATION ID_USER and ID_GROUP are Unique keys of the table GROUPS ID_USER is a Unique Keys of table USERS ID_USER , ID_GROUP, ID_ORGANIZATION are Unique Keys for the table ORGANIZATION I was trying to create a validation form with SQLFORM using IS_NOT_IN_DB fuction but i dint' find a solution, i found lot of solution for 2 field check but not for 3. For the SQLFORM of the table GROUPS i didnt' got problems infact i wrote: db.groups.id_group.requires = IS_NOT_IN_DB (db(db.users.id_user== request.vars.id_user),db.groups.id_group.) Can someone help me posting just an example that i can try for the validation of the value of the ORGANIZATIONE TABLE? Thank you
