What does Dynaset(Inconsistent Updates) Mean

[gyli84]

I have a query drawing info from 3 tables in which there is a many-to-one-to-many relationship in order to create a form (I am creating a helpdesk system and have a staff table linked to a computer and calls/problem details table by USER ID). In Access help it says that this query (3 tables with a many-to-one-to-many relationship) is not updatable and won't change the data in the underlying table directly through the query datasheet but it also says I can update data in the underlying tables if I create a form and set its recordset type to "Dynaset (Inconsistent Updates)". I have done this and have found that my underlying tables are updated as I enter information on the form but I would like to know whether Dynaset (Inconsistent Updates) implicates that there are disadvantages and limitations to this. What does Dynaset(Inconsistent updates) mean or is that just a name? How does it differ from just a "Dynaset" recordset type?

Thanks

 

[Liv Manto]

inconsistent

The state of a multiple-table Recordset object that enables you to update all fields (columns).

For example, in a Recordset created by joining two tables in a one-to-many join (as in a Customers and Orders table), you can update Orders.CustomerID so that it doesn’t match Customers.CustomerID, unless referential integrity disables the update.