Hope this info gives us a clue. Somtimes I can't see the forest for all the trees!
>
>Need:
>
>- Connection parameters ( shared,async,packed... )
SHARED
>- view definition

SELECT *;
 FROM  property!propnum LEFT OUTER JOIN property!pocontact ;
   ON  Propnum.contactid = Pocontact.memoid;
 WHERE SUBSTRC(Propnum.groupid,1,2) = "PN";
 ORDER BY Propnum.nproperty

>- fields mapping

Field Names with Data Type and Length
Table : PNVIEW
     Field         Size
  1: Lcancel       L(1)
  2: Donated       L(1)
  3: Nproperty     I(4)
  4: Dateissue     D(8)
  5: Cinvoice      C(9)
  6: Serialno      C(17)
  7: Acqcost       N(12)
  8: Descrip       C(35)
  9: Orgcode       C(11)
 10: Groupid       C(9)
 11: Notes         M(4)
 12: Dup_pn        N(4)
 13: Contactid     I(4)
 14: Memosent      L(1)
 15: Memorecvd     L(1)
 16: Inputuser     C(15)
 17: Inputdate     D(8)
 18: Memoid        I(4)
 19: Send_fname    C(20)
 20: Send_lname    C(25)
 21: Send_add1     C(40)
                    ___
                    233

>- n° records
26957 IN 5.67sec to browse
>
>Fabio