adding a query to a query makes it non-updatable

[Honestmath]

hey all,

what makes a query non-updatable?

i have this query "qryTrades" that links to 2 tables (tblTrades and tblTrades2) that are right joined together. the recordset is updatable when i run it (except on calculated fields, of course).

i have another query "qryPrices" that is linked to a table (tblAssets) and another query (with underlying table tblPrices). when i run it, the recordset is updatable.

when i add qryPrices to qryTrades, qryTrades becomes non-updatable. why? is there something i can do about this? i've tried breaking qryPrices into its components and putting them directly into qryTrades, but the same thing happens.

is there some limit to the number of parented queries that keeps a recordset updatable??

thnx for the help -- math

 

[cmmrfrds]

The database engine has to establish which unique record is to be updated, so there has to be an unique value for a record in any query to be updateable. This means no aggregate query is updatable. If one of the queries is an aggregate (depending on how it is used) then it will not be updatable. Aggregate is a query with Sum, Count, Group by, etc.... Hope this gives you a starting point to evaluate your queries.