Since you are having troubles, can I suggest you rename the following: registos.obra.cliente and registos.obra.vendedor
to registos.obra.cliente_id registos.obra.vendedor_id This is because this field IS a foreign key, which holds the cliente.id .... Now you have TWO fields, "cliente" - one a table name, one a field name.... if you rename this, it will remind you better what you are looking at in your controllers. See if this helps... On Wed, Aug 12, 2009 at 4:14 AM, Carlos Aboim <abo...@gmail.com> wrote: > I've you seen my dpaste?? > My models are like this http://dpaste.com/hold/78289/ > Is the field 'vendedor' in the table 'obras' that I am having trouble! > > May I use *required* parameter in the 'vendedor' field instead? > It seams so linear but I cant make it work! > > thank you > C Aboim > > > > > 2009/8/12 mdipierro <mdipie...@cs.depaul.edu> > > >> The only things I can think of are: >> 1) requires is mispelled >> 2) requires is overwritten somewhere else >> >> Can you post the code? >> >> On Aug 12, 3:23 am, Carlos Aboim <abo...@gmail.com> wrote: >> > Hi, >> > In fact I was using requires=[IS_IN_SET(…)] >> > >> > Changed to requires=IS_IN_SET(....), but still doesn't work!! >> > >> > help!! Thanks >> > >> > Carlos Aboim >> > >> > 2009/8/11 mdipierro <mdipie...@cs.depaul.edu> >> > >> > >> > >> > > requires=IS_IN_SET(....) >> > >> > > validation+dropdown >> > >> > > requires=[IS_IN_SET(....)] >> > >> > > validation but not dropdown. ;-) >> > >> > > On Aug 11, 11:01 am, Carlos Aboim <abo...@gmail.com> wrote: >> > > > Hi everyone >> > >> > > > I am using a model like: >> > >> > > >http://dpaste.com/hold/78289/ >> > >> > > > - the field 'vendedor' >> > > > - the field 'cliente' >> > >> > > > in model 'obras' should show a dropdown menu from IS_IN_SET >> ('vendedor') >> > > and >> > > > from other table reference ('cliente') parameter >> > > > but it doesn't show up no dropdown menus >> > >> > > > Any better aproach?? >> > >> > > > thank you >> > > > Carlos Aboim >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---