Access Query Does Not Allow Data Entry

[sparker75]

Hello,



I'm trying to build an update query with three tables. But when I add the third table it does not allow edits.

This is the query before I add the third table. It allows data entry

SELECT tblOrderStatus.OrderNum, tblOrderDetails.PlannerGroup, tblOrderStatus.SID, tblOrderStatus.PlannerUserName, tblOrderStatus.AssignUsername
FROM tblOrderDetails INNER JOIN tblOrderStatus ON tblOrderDetails.OrderNum = tblOrderStatus.OrderNum
WHERE (((tblOrderStatus.SID)=1));

This is with the third table that does not allow data entry. The join between the third table is LEFT JOIN tblObjectUser ON tblOrderDetails.PlannerGroup = tblObjectUser.PlannerGroupID

SELECT tblOrderStatus.OrderNum, tblOrderDetails.PlannerGroup, tblOrderStatus.SID, tblOrderStatus.PlannerUserName, tblOrderStatus.AssignUsername
FROM (tblOrderDetails INNER JOIN tblOrderStatus ON tblOrderDetails.OrderNum = tblOrderStatus.OrderNum) LEFT JOIN tblObjectUser ON tblOrderDetails.PlannerGroup = tblObjectUser.PlannerGroupID
WHERE (((tblOrderStatus.SID)=1));

[June7]

Review http://allenbrowne.com/ser-61.html Guessing the 7th cause pertains.

Why are you including multiple tables?

[sparker75]

I need to link the tables to get the username that will be added as an update

tblObjectUser.USERNAME will be updated to tblOrderStatus.PlannerUserName and tblOrderStatus.AssignUsername

The link is LEFT JOIN tblObjectUser ON tblOrderDetails.PlannerGroup = tblObjectUser.PlannerGroupID


SELECT tblOrderStatus.OrderNum, tblOrderDetails.PlannerGroup, tblOrderStatus.SID, tblOrderStatus.PlannerUserName, tblOrderStatus.AssignUsername, tblObjectUser.USERNAME
FROM (tblOrderDetails INNER JOIN tblOrderStatus ON tblOrderDetails.OrderNum = tblOrderStatus.OrderNum) LEFT JOIN tblObjectUser ON tblOrderDetails.PlannerGroup = tblObjectUser.PlannerGroupID
WHERE (((tblOrderStatus.SID)=1));


This will be done as a mass update.

[June7]

Then might have to use DLookup() but I don't really understand what you are trying to accomplish. Would have to review your data structure.

[GinaWhipp]

Is there any way you could run a second query against your data set to add the User? Because as long as there is a LEFT JOIN it won't work.