Howdy,

I'm simply trying to create a View through the View designer which connects my main table to 2 other tables by way of outer joins.

When I do it in the view designer, and save it - it will run correctly, but when I try to modidy the view - ir crashes.
It seems that the view designer creates the SQL syntax incorrectly.

1. This is what the View Designer gives me as the SQL syntax

SELECT MAIN.ID, NAMES.FNAME, STATES.STATE ;
FROM MAIN LEFT OUTER JOIN NAMES;
LEFT OUTER JOIN STATES ;
ON MAIN.name = STATES.name ;
ON MAIN.id = NAMES.id

2. Running it is O.K.

3. When I save the view and try to modify it I get the Fox error:
SQL: Column 'NAME' is not found.

John F.
Needs View help in NYC