Hi

try this end test:
- build a view for first part

SELECT * FROM  property!propnum WHERE LEFT(Propnum.groupid,2) == "PN"

- timing this view
- build a view for second part

SELECT pocontact.* FROM  property!pocontact JOIN property!propnum ;
ON  Pocontact.memoid = Propnum.contactid AND LEFT(Propnum.groupid,2) == "PN"

- timing this view

if timing1 + timing2>original timing, the time for requery the view is
only ODBC fetch timing, and you cannot reduce it on ODBC enviroment.

Fabio