>MSDN article Q156631 says quite clearly that the IN() filter condition doesn't work! Thats all very well but how do I do a parameterized view for a numbers of customer IDs when I don't know how many I will need to look for?

One way to do this is to build a list of the IDs in a cursor or table. Then do the view with a nested query or join (you can't do this in the vfp view designer, of course, though - but that's no real obstacle - use eView instead.)

Your view might look for example like:

CREATE SQL VIEW "myview" ;
AS SELECT * FROM mytable ;
where mytable.cid in (select temp.cid from temp)