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
--
