Hello,
Is it possible to declare UNIQUE constraint over many fields and how...
Does using IS_NOT_IN_DB() on the differents fields will work?
...num_part1.requires=IS_NOT_IN_DB(db((db.ref_fnaregistry.num_part1==request.vars.num_part1)
&
(db.ref_fnaregistry.num_part2==request.vars.num_part2) &
(db.ref_fnaregistry.num_part3==request.vars.num_part3) &
(db.ref_fnaregistry.title==request.vars.title)),db.ref_fnaregistry.num_part1)
etc.
But I think i need to concatenate...
If there is no way I think I know how I will do it.
Richard
