[web2py] Populating widgets with queries

[Mike Girard]

I have a checkboxes widget which I invoke like so:

form = SQLFORM.factory(
        Field('test', 
        type='string',
        requires=IS_IN_DB(db, db.city.name_url, '%(name)s', multiple=True), 
        widget=lambda f, v: SQLFORM.widgets.checkboxes.widget(f, v, 
style='divs'),
        default = 'New-York'), formstyle='divs')

I use requires=IS_IN_DB solely to populate the checkboxes with fresh data. 
I don't really need the validation. Now I would prefer to spread the data 
in the one table being used across multiple checkbox groups. Is there an 
out-of-the-box way to populate form elements with queries instead of just 
binding them to tables? 

--