General question - uneditable query results

[matt beamish]

This is a very general question, but a problem that I hit repeatedly in my low level database work - I am not trained in databases at all, but have to use them to get on.

I find that when basing forms on select queries that are stacked on each other - (ie one query shows the results of two tables, that query then is joined to another table in another query and so on) that at some stage the query results become uneditable.

I cannot see why this happens. Is there a simple database rule that I am not adhering to here? Is there a maximum number of tables that can be joined in queries and form the basis of editable datasets in form view.

Sorry for vagueness!

Matt

 

[chergh]

There are lots of rules that decide if a recordset is updateable or not. Use the Access help and search for "Updatable Recordset" this will provide you with the info you need.

 

[matt beamish]

Thanks - so now I have found that query reults are uneditable when: "Query based on three or more tables in which there is a many-to-one-to-many relationship" but a workaround is to set the form's RecordsetType property to Dynaset (Inconsistent Updates).
Matt