try with a macro

in (&vp_isalesdocid)



Thank you Fabio for your suggestion but the backend SQL Server doesn't understand the macro substitution syntax & so this doesn't work.
I don't really know why VFP only takes into account the first value in the IN( x,y,z) clause so I think I'll settle for a SQL Pass Through approach because this does work.

BTW: I also tested manually creating the remote view but this gives me the same result as the VFP9 View designer.

Mark