I have 2 tables in sql server having parent child relation. I saved a crosstab query as view on the child table. I created a form whose recordsource is a join of parent table and view of child table. All the fields of the view are non updatable in the form and I only need to allow updates to some fields in parent table. I set the unique table property for the form as the parent table. But still Iam getting error "This recordset is not updatable". Can anyone please help?