>Hi Mat,
>
>What about the problem I have heard described concerning having more than one table in a view? From what I understand, SQL Server doesn't like it when you join two or more related tables together and use it to modify the data. Have I misunderstood something? Also, do you create any views on the SQL side or do you do all of that on the VFP side?
>
>TIA,
>
>Brian
Brain,
I haven't seen that problem, all of my views performing updates only use a single table. I have business objects that contain multiple views, but not two table joins for updating. All of my views are created on the VFP side.
Kind Regards,
Mat