There is a query q04InvPurchaseSub03. On the image 001 it can be seen it is updatable. This query is a subquery to query q02InvPurchases that stores the subform for Purchase invoices. Since I assume all TOTAL QUERIES are not updatable, q04InvPurchaseSub03 is not a TOTAL QUERY but still returns only the latest record against every Inventory Item or any other item bought that is not Inventory. This demo we are working on, the policy is for a retail business to have a mark up on latest purchase price to get to the sales price.
I have a table t01CombindedEntity where all 10 entities(i.e. Banks, Employees, Suppliers, Customers, Inventory, Goods and services etc.) come together. We created a subquery q04CombinedEntity09 which lists all 277 records in t01CombinedEntity. This 277 include 29 Inventory Items and 73 Goods and Services Items. It all works perfect to join q04CombinedEntity09 and q04InvPurchaseSub03. The 29 +73 items gives 102 items that should have a latest purchase price and they lie in separate tables but come together in t01CombinedEntity. It can be seen in Image 002 that q04CombinedEntity09 is also updatable.
I need to join q04CombinedEntity09 with q02InvSalesSub to get the sales Price on the sales invoice. Joining these queries in q02InvSalesSub makes q02InvSalesSub not updatable. I don’t see right now why if the two queries are seperately updateable turn to not updatable when joined.
To return the salesprice by expression makes the system hang.