>#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?