Hi Alan, Thanks for your replies. They pointed me in the right direction to solve the multiselect problem. I am left with one small problem.
The form that contains the multiselect also contains an autocomplete function: def index(): .... form=SQLFORM.factory( Field('word',label='Trefwoord',length=128,requires=\ IS_IN_DB(db(db.NetworkKeyword.networkID==session.hubnetworkID),db.NetworkKeyword.word,'% (word)s',\ zero='Select a value')), Field('locality_args',label='Plaats',length=64,requires=IS_NOT_EMPTY()),separator=False) .... return dict(form=form,rows=rows) def locality_args_autocomplete(): rows=db((db.NodeKeyword.word==request.args(0))&(db.NodeKeyword.nodeID==db.Address.nodeID)& \ (db.Address.locality.like(request.vars.term+'%')))\ .select(db.Address.locality,distinct=True,orderby=db.Address.locality).as_list() result=[r['locality']for r in rows] return response.json(result) .... and in the view: <script type="text/javascript"> $(function() { $("#no_table_locality_args").autocomplete({ source: "{{=URL('hubaddressbook', 'locality_args_autocomplete',args='javascript:$ (select#no_table_word).val();')}}", minLength: 2 }); }); </script> ... which gives me an invalid path (args) error. When I set args='software engineer' in the source and db.NodeKeyword.word=='software engineer' in the locality_args_autocomplete() function, the code works, however, with form.vars.word in the view and request.args(0) in the function it doesn't. Do you know with what code I have to replace 'software engineer' to get both functions to work. Kind regards, Annet.