>Hi,
> I am using View designer to design my view
> I have 5 tables, I need ot combine then into a view. However it return "SQL Column is not found" even the field is exist in the table. Again, it return "Base table is not match with view" even I don change the structure of base table. Any idea??
>
>Thank you

Hi John,

View Designer just doesn't work properly with parallel joins from one table to 2 or more other tables. But you can create such a view programmatically and it will work. Just do not open it then in a View Designer.
Also you may try Erik Moore's eView from Downloads section