ms access + query - adding table makes it not updatable

i have a query that returns a datasheet, and then get an message that says the recordset is not updateable - i have narrowed it down to one of the tables, if i remove the table i can update the fields, if i add the table i cant, the table has a relantionship to the main table, i cant figure out what the problem is - any suggestions on what i can look at to fix the issue.
dkilbyAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
see this link

When can I update data from a query?
http://msdn.microsoft.com/en-us/library/aa198446%28office.10%29.aspx

in most cases, as stated in the link
setting the forms recordsettype  to Dynaset (Inconsistent Updates). will do the job
0
 
dkilbyAuthor Commented:
excellent - that was easy fix - thanks
0
All Courses

From novice to tech pro — start learning today.