Join Issues (can not enter data)

[Michelle]

I have a query with the follwoing sql code that works. Then the second code
is basicly the same however it does not work.
The first code will let me enter data the second one just beeps at me when I
try to enter data.

SQL Code that works thisjoins 2 tables tblRHUInmtinfo & tblESSLog and lets
you enter data into tblESSLog

SELECT tblRHUInmtinfo.IN_INMNUM, tblRHUInmtinfo.IN_NAME,
tblRHUInmtinfo.IN_RACE, tblRHUInmtinfo.IN_SECTION, tblRHUInmtinfo.BSCB,
tblRHUInmtinfo.SEP, tblESSLog.EXERCISE, tblESSLog.SHOWER, tblESSLog.[YARD #],
tblESSLog.RAZOR, tblESSLog.SCREAM, tblESSLog.MIRROR, tblESSLog.DATE
FROM tblRHUInmtinfo LEFT JOIN tblESSLog ON tblRHUInmtinfo.BSCB =
tblESSLog.BSCB
WHERE (((tblRHUInmtinfo.BSCB) Like "*" & [Enter Pod:] & "*"))
ORDER BY tblRHUInmtinfo.BSCB;


SQL Code that does not work this joins two tables tblInmtinfo &tblInmates
(this one just beeps at me when I try to enter any data into it)

SELECT tblInmtinfo.IN_NAME, tblInmtinfo.IN_INMNUM, tblInmates.Gang,
tblInmates.[Nick Name], tblInmates.Rank, tblInmates.[STG Misconducts],
tblInmates.Comments, tblInmates.Photo, tblInmates.[Tattoo 1],
tblInmates.[Tattoo 2], tblInmates.[Tattoo 3], tblInmates.Files
FROM tblInmates LEFT JOIN tblInmtinfo ON tblInmates.[DOC Number] =
tblInmtinfo.IN_INMNUM
WHERE (((tblInmates.Gang)="215"));

 

[Baz]

Make sure that the primary key column from each table is included in the
SELECT list.