Mark,

Thanks for the info. More knowledge I can remember for the future.

I was able to find a way to get multiple numbers.

local invc_nos
STORE "" TO invc_nos

SELECT maintbl
DO WHILE !EOF()
invc_nos = invc_nos + IIF(EMPTY(invc_nos), "",",") + ALLTRIM(STR(maintbl.invc_no))
SKIP
ENDDO

CREATE SQL VIEW invc_ln_view;
CONNECTION myconnect AS;
SELECT invc_ln.invc_ln_no, invc_ln.invc_no;
FROM PROD.invc_ln invc_ln;
WHERE invc_ln.invc_no IN (&invc_nos)

It's rough trying to go from dbf to dbc without any prior knowledge of dbc.
Again, thanks for responding