Hi!

In addition to what Nick said, check if total number of fields in view do nto exseed 255. If yes, that is a problem (it is limitation of VFP for all kinds of record sets).

>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