I have a combo box on a form to select a company name. The list of valid company names is derived from a query, q, and so I have:
t = db.t_tasks c = db.t_companies t.f_company.requires = IS_EMPTY_OR(IS_IN_DB( db(q), c.id, '%(f_name)s', zero="All")) That works, but the query may return more than one row for any given company, and thus the combo repeats the company name, once for each row. I need to make the query DISTINCT, but can't see how to do that. Can anyone help? Thanks, Keith -- We're looking for good Linux people: http://www.tiger-computing.co.uk/jobs --