Query not working

[Guest]

Hi groupies

I have the following SQL:

SELECT tblCompartments.lngProjectID, tblCompartments.lngCompartmentID,
tblBlocks.lngCompartmentID, tblBlocks.lngBlockID, tblBlocks.strBlock,
tblReefers.lngReeferID, tblReefers.strSequence
FROM (tblProjects INNER JOIN (tblCompartments INNER JOIN tblBlocks ON
tblCompartments.lngCompartmentID = tblBlocks.lngCompartmentID) ON
tblProjects.lngProjectID = tblCompartments.lngProjectID) LEFT JOIN tblReefers
ON tblBlocks.lngBlockID = tblReefers.lngBlockID
ORDER BY tblProjects.strProject, tblCompartments.strCompartment,
tblBlocks.strBlock;

lngReeferId is an autonumber. My problem is that I can not enter anything in
strSequence until I click in a different record. This is supposed to work
seamlessly in a form but if I can't get it to work in the query, the form
won't work either.

Any ideas?

 

[strive4peace]

Hi CJ,

your recordset is not updatable because you are joining information from
multiple tables that, presumeably, are not in a 1:1 relationship with
each other -- you also are using a LEFT JOIN

It is best to design a seperate form/subform for each table you wish to
enter information into

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[CJ]

Hi Crystal
That's the conclusion that I have come to. It is just too complicated to
complete in one step.

Thanks.

 

[strive4peace]

you're welcome, CJ happy to help

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*