One level deeper and its happening again. I have a query that takes in two other querys. I can edit the data in both of the parent queries, but not the data in this query. I checked for control words, didn't see any. Sort of as to a loss why I keep bumping into this.
The SQL is as follows:
SELECT QRoll.ID, QRoll.munino, QRoll.rollnotype, QRoll.rollno, QRoll.recordtype, QRoll.ward, QRoll.hospital, QRoll.school, QRoll.neighborhood, QRoll.rhota, QRoll.psta, QRoll.surveydesc, QRoll.moresurvey, QRoll.ownership, QRoll.dwellings, QRoll.frontage, QRoll.frontageum, QRoll.addr, QRoll.lud, QRoll.community, QRoll.RollID, QControl.*
FROM QControl LEFT JOIN QRoll ON QControl.LookUp = QRoll.RollID;
QControl:
SELECT Control.MuniCtl, Control.RollType, Control.RolllNo, [MuniCtl] & [RollType] & Format([RolllNo],"000000.000") AS LookUp
FROM Control;
QRoll
SELECT Roll.ID, Roll.munino, Roll.rollnotype, Roll.rollno, Roll.recordtype, Roll.ward, Roll.hospital, Roll.school, Roll.neighborhood, Roll.rhota, Roll.psta, Roll.surveydesc, Roll.moresurvey, Roll.ownership, Roll.dwellings, Roll.frontage, Roll.frontageum, Roll.addr, Roll.lud, Roll.community, [munino] & [rollnotype] & Format([rollno],"000000.000") AS RollID
FROM Roll;