hi josh,

the starting query is called demographicsCurLocation, which is custom SQL. It has a column called 'room', that points to lookups.rooms, which is also custom SQL.

In other places I have successfully pointed a lookup at custom SQL (as opposed to a built-in table), so I would have expected this to work.

thanks.