Thanks Massimo, I can do that. Only slight issue is the computed field physically takes space in the database.
I was a bit puzzled why a virtualfield would not work because I thought it was introduced for precisely this kind of use. -- D On Aug 9, 1:54 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > You must have computed field that contains the contend you want to use > 'name + town' > > On Aug 8, 7:06 pm, villas <villa...@gmail.com> wrote: > > > I have the following requirements: > > > 1) The widget to show the 'name' but save the 'id' > > 2) The widget to reveal the fields 'name' plus 'town' in the drop down > > selection. > > > The built-in autocomplete widget provides 1) but I cannot see how to > > do 2). > > > The code in sqlhtml.py seems rather complex. I tried to use a > > virtualfield to join the two fields together and show that, but it > > does not seem to work. > > > Mr Freeze's slice 66 seems like it might be easier to adapt, but I > > would need to add both requirements, which is still probably beyond my > > skills. > > (http://www.web2pyslices.com/main/slices/take_slice/66) > > > Can anyone give me a pointer, thanks. > > -- > > David > >