Started to rework this. Changed to an inner join (I believe!) as suggested.
rows=db(db.data.provider==db.providers.id).select(db.data.lon,
db.data.lat, db.providers.name)
Chris
On Mon, Sep 12, 2011 at 9:54 PM, Chris Rowson
<christopherrow...@gmail.com> wrote:
> Thank you both. I shall revisit, replace with a join and put the logic
> into the controller rather than the view :-)
>
> Chris
>
