Forum Discussion

pia92's avatar
pia92
Copper Contributor
Sep 23, 2022

Ms Access cannot edit the data in a query with two table source

Hi,    Can anybody help me what to do on my Access form. My form data source is a query with two tables. Initially, I can edit my data in a form with 1 table source but when I added another table w...
access
arnel_gp's avatar
arnel_gp
Steel Contributor
Sep 23, 2022
1=1 relationship?
you can just combine it into 1 table if that is the case.
also try to make the other Pk an FK.
pia92's avatar
pia92
Copper Contributor
Sep 23, 2022
Hi arnel_gp,

To simplify, I just combine the 2 tables into 1.
Thank you!😊

Resources