Stuart McLachlan
stuart at lexacorp.com.pg
Fri Dec 3 02:27:49 CST 2010
Have you included the PK of the child record in the view. Without it, it will definietly be non- updateable. -- Stuart On 1 Dec 2010 at 8:16, jwcolby wrote: > I create a view of parent / child, joined on FK etc. Filter to one > specific parent using the parent's PKID. I then try to edit a field > in the child and it doesn't do anything, IOW it is locked for some > reason. I thought that simple views like this are supposed to be > editable. > > -- > John W. Colby > www.ColbyConsulting.com > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >