Can't modify data

[radek225]

I've created a query from two tables using left join, and it works great.

SELECT tblImpozycjaSzczegoly.id_tblImpozycja, tblImpozycjaSzczegoly.id_imp_szcz, tblImpozycjaSzczegoly.NRskladki, tblImpozycjaSzczegoly.SposobUlozenia, tblImpozycjaSzczegoly.IloscUzytkow, tblImpozycjaSzczegoly.Naklad, tblImpozycjaSzczegoly.Opis, tblCTP.Id_ctp, tblCTP.typ_plyt, tblCTP.potrzebne_plyty, tblCTP.uszkodzone_plyty, tblCTP.uszkodzone_fabrycznie, tblCTP.[Rozdzielczosc/Liniatura], tblCTP.opis
FROM tblImpozycjaSzczegoly LEFT JOIN tblCTP ON tblImpozycjaSzczegoly.id_imp_szcz = tblCTp.id_imp_szcz;

But now I want to add one more table in the same configuration as tblCTP. But Even if my query works I can't modify and add data. What should I do?

SELECT tblImpozycjaSzczegoly.id_tblImpozycja, tblImpozycjaSzczegoly.id_imp_szcz, tblImpozycjaSzczegoly.NRskladki, tblImpozycjaSzczegoly.SposobUlozenia, tblImpozycjaSzczegoly.IloscUzytkow, tblImpozycjaSzczegoly.Naklad, tblImpozycjaSzczegoly.Opis, tblCTP.Id_ctp, tblCTP.typ_plyt, tblCTP.potrzebne_plyty, tblCTP.uszkodzone_plyty, tblCTP.uszkodzone_fabrycznie, tblCTP.[Rozdzielczosc/Liniatura], tblCTP.opis, tbl_cyfra.ID_cyfra, tbl_cyfra.Ark_CMYK, tbl_cyfra.Odpad_CMYK, tbl_cyfra.Ark_BW, tbl_cyfra.Odpad_BW, tbl_cyfra.Duplex, tbl_cyfra.Opis
FROM (tblImpozycjaSzczegoly LEFT JOIN tblCTP ON tblImpozycjaSzczegoly.id_imp_szcz = tblCTP.id_imp_szcz) LEFT JOIN tbl_cyfra ON tblImpozycjaSzczegoly.Id_imp_szcz = tbl_cyfra.id_imp_szcz;

 

[pr2-eugin]

You might have made the query read only. Check out if any of the ones in this list fits your scenario. http://allenbrowne.com/ser-61.html

 

[radek225]

I think it could be "It has a subquery in the SELECT clause. Uncheck the Show box under your subquery, or use a domain aggregation function instead." or "It uses JOINs of different directions on multiple tables in the FROM clause. Remove some tables." In first case, How can I correctly use "Group by"? In second case it Isn't possible to have two tables with relation to common table?

 

[CJ_London]

all group by queries are not updateable.

you should be editing data in a form and using subforms for each linked table rather than having one big query. The risk with a big query is that if you only update one side of a one to many relationship, the link will fail.

The other benefit of using a form is you can change the recordset type from 'Dynaset' to 'Dynaset - inconsistent updates' which sometimes makes an unupdateable recordsource updateable.