Hi,
I have a local view with syntax,
SELECT Suspense.policyno, Suspense.claim, Suspense.drftamt,;
Suspense.dduedate, Suspense.claimname, Suspense.dol, Suspense.ssn,;
Suspense.adjustor, Suspense.clmoffice, Suspense.ntlogin,;
Suspense.controlnum, Suspense.susp_code, Suspense.den_code,;
Suspense.accepted, Suspense.denied;
FROM suspense;
WHERE Suspense.clmoffice IN (?clmlist)

where clmlist is variable.

It seems that when I pass "001","007","008" as the clmlist variable, the local view only returns records that have clmoffice="001" (or whatever I pass in before the first comma).

I also tried creating the view dynamically at run-time, but can't get the local view to refresh the data in a grid.

Would be VERY GRATEFUL for any tips...
THANKS!

Suzi Taylor