Well, if anyone is reading this thread. I've tried building the view step by step to determine when it become "unreadable" after it is saved.

I've simplified it down to this and still have the problem:

SELECT Lnai.Qty, Lnai.Cost;
FROM ;
{oj dbo.tblLNaiTransactionLog Lnai ;
LEFT OUTER JOIN dbo.ItemMaster Im ;
ON Lnai.KeyField = Im.KeyField};
WHERE Lnai.DateRcvd BETWEEN '04/04/04' AND '05/01/04'

If I try and re-load the view after saving it, I get an error and it refuses to let me into the designer but rather pops up the SQL page offering for me to make changes. I have now found that I can remove the two braces {} and the word 'obj' from the SQL statement and it will then allow me to renter the design screen. But, VPM will immediately put the {obj ....} back into the SQL statement, starting the problem over again.

Can anyone tell my why selecting OUTER LEFT JOIN places the {obj ... } into the SQL statement and why it chokes on it after it is there?

Thanks,
Robert