Query question

[Wulf13]

I have a query that joins three tables. The first table being the master list with all personnel listed and the other two are tables containing information about a specific record. When I run this select query it allows me to add/edit information. However if I add a fourth related table, it allows me to view the information but not edit any of it. Can someone tell me why?

I've always been weak in understanding how queries really work and could use some help. Thank you.

 

[Wulf13]

Here is my query, I'm sure it looks pretty ugly:

SELECT masterList.organization, offPRP.actionTaken, masterList.SSN, masterList.EAL, masterList.NoCode, masterList.AuditTrail, masterList.name, forecastedMECSQ.indexNumber, issuedMECSQ.indexNumber
FROM ((masterList LEFT JOIN offPRP ON masterList.SSN = offPRP.SSN) LEFT JOIN forecastedMECSQ ON masterList.SSN = forecastedMECSQ.SSN) LEFT JOIN issuedMECSQ ON masterList.SSN = issuedMECSQ.SSN
WHERE (((masterList.organization) Like [Forms]![masterListQ]![Combo58] & "*"))
ORDER BY masterList.name;

When I delete the reference to either the forecastedMECSQ or the issuedMECSQ, it lets me edit the information. Any pointers are appreciated.