>Hi Tore
>
>>You can do this in many ways. One possibility is to create a file ALLRECORDS.YES on your machine, and add something like this

>>#IF FILE("ALLRECORDS.YES")
>>  #DEFINE ALLRECORDS .T.
>>#ELSE
>>  #DEFINE ALLRECORDS .F.
>>#ENDIF

>>Your select will then be:

>>WHERE ALLRECORDS or (COALESCE(TPACKINGLIST.IPKLNO, 0) != 0 ;
>>		OR TPACKINGLIST.IID = ?VP_IID)

>
>Thanks Tore, I like the idea. However, one more thing, how will I get in the # commands into the view?

Sorry, I had a temporary brain malfunction! :-)

WHERE file('ALLRECORDS.YES') or (COALESCE(TPACKINGLIST.IPKLNO, 0) != 0 ;
  OR TPACKINGLIST.IID = ?VP_IID)