Dynaset (Inconsistent Updates)

I think that I do not exaggerate if I state that "inconstistent updates" will spoil your complete application. And "spoil" is much too polite.

Database applications are used to guarantee data consistency for accounting and other importing reasons. This is why you should never ever create inconsistencies.

Furthermore, if your tables already contain inconsistent data (orphan records on the n-side of an 1-n relationship for example) then it is not possible to "repair" the relationships between the tables. You will have to first correct the data in the 1-side-table(s) before you can work professionally.
Depending on the amount of data this might be impossible thus you might get into severe trouble.

The solution of your problem:

1. Correct the structure (referential integrity) of your tables
2. Analyse the "strange" query to find out why it is not updateable (did you activate aggregate functions? recursive queries or sub queries?)

I am not saying that data within my database is inconsistent, merely that by having a query drawing information from 3 tables in order to create a form (a staff table is linked both to a computer table and a calls/problem details table-I am creating a helpdesk) I have to choose the "Dynaset(Inconsistent Updates)" option as the recordset type for the form and I would like to know what ths means and how it differs from a "Dynaset" recordset type. Entering data on the form seemed to update fields in the underlying tables ok??