Hello Readers,
I am trying to update data on a form that is based on a query having a
many-to-one-to-many relationship. I found this exciting link that
seemed to have the solution for me:
http://support.microsoft.com/?kbid=304473
I referred to the part in it that says:
Query based on three or more tables in which there is a
many-to-one-to-many relationship:
"Though you can't update the data in the query directly, you can
update the data in a form or data access page based on the query if
the form's RecordsetType property is set to Dynaset (Inconsistent
Updates)."
I implemented it on the form in question but I am still not allowed
any updates. Any ideas? What more should I be checking for?
Thanks for any help.
Carmela.