thanks you very much, problem solved with that instruction. regards
On 29 jul, 17:57, mdipierro <[email protected]> wrote: > You are dernormalizing in a link table. Not a good idea. Let's go it b > the book: > > with crud.create(db.familia_riesgo) > > The models are like: > > db.define_table('familia',Field('ficha','string'),format='%(ficha)s') > > db.define_table('riesgo',Field('nombre','string'),format='%(nombre)s') > > db.define_table('familia_riesgo', > Field('familia_id',db.familia), > Field('riesgo_id',db.risiego) > ) > > # this is not necessary > # db.familia_riesgo.familia_id.requires=IS_IN_DB(db,'familia.ficha') > > # this is one way to do it > db.familia_riesgo.riesgo_id.requires=IS_IN_DB(db,'riesgo.id','% > (nobre)s', > > _and=IS_NOT_IN_DB(db(db.familia_riesgo.familia_id==request.vars.familia_id),'familia_riesgo.riesgo_id')) > > On Jul 29, 9:17 am, web2py noob <[email protected]> wrote: > > > what can I do for that? > > > thanks in advance > > > On 29 jul, 09:37, web2py noob <[email protected]> wrote: > > > > On 29 jul, 09:20, mdipierro <[email protected]> wrote: > > > > > It depends on how you insert records in familia_risiego > > > > with crud.create(db.familia_riesgo) > > > > The models are like: > > > > db.define_table('familia',Field('ficha','string')) > > > > db.define_table('riesgo',Field('nombre','string')) > > > > db.define_table('familia_riesgo', > > > Field('familia_id','string'), > > > Field('riesgo_id','string') > > > ) > > > > db.familia_riesgo.familia_id.requires=IS_IN_DB(db,'familia.ficha') > > > > # I'm tryied this, but don't work; just block the insert if riesgo_id > > > repeats even with a different familia_id > > > db.familia_riesgo.riesgo_id.requires=IS_IN_DB(db,'riesgo.nombre')),IS_NOT_IN_DB(db,'familia_riesgo.riesgo_id') > > > > Regards.
