Hi, In Lesson 1 of 2013 Expert 8; Richards mentions that sometimes fields are not update-able when Forms made from Record Sources from Queries with Many-to-Many relationships.  Why is that and is there a work around?
I guess I'm having trouble with Many-to-Many in general, but specifically adding records.  
Any help or guidance would be greatly appreciated.
FYI I have viewed all Expert Courses 1-30

Thanks
John

---

Reply from Alex Hedley:

Do you need all the fields in your Query?
You could just remove the join that is causing the record set not to update and work with that instead

See an explanation here.