Search form not allowing editing

[ds_8805]

Hello everyone.I have search form that is created based on a query. The query has 2 tables called maintable and info of contacts. In the search form when i search for products, it will say who is the contact person for that product is. I have designed it in such a way that I would allow the user to edit the record that they are searched too. It all works perfectly fine. Except that now I am try to add a new table into the query cos I want the search form to display more info. However the problem now is that it would not allow me to edit any of the details. When I take out the new table I added in from the query, I am able to edit the records. However, when the new table is added I am not able to. Could someone pls tell me why this might be caused and how to solve it???

Thanks

 

[DCrake]

This is because the newly introduced table is making the query non updateable. Take a look at the join you are using are they correct? should be Foreign key to Primary Key. Or the field in the new table doe snot have an index on the join field.

David

 

[ds_8805]

Thank u very much for ur help. It helped!