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
