Unusual query behaviour

S

StvJston

I have a subform in datasheet view that allows a drilled down view of report
specifications.

The subform is bound to the query as a datasource. One of the controls is a
combo box that allows the user to select a "group" to tie to the Line map.

When entering a new line the cross reference table can be populated and the
form works as expected..

Once the record is entered the group reference cannot be edited. I realize
this is because the cross reference table doesn't contain an entry but I'd
like to correct this behaviour without having to perform a external append..

The relevant query joins are below. Linemap to Xref 1 to 1 relationship
(unique)
ProgGrpID to xRef 1 to many relationship

SELECT tblReportLineMap.RptSecID, tblRptLineGroupXref.RptGrpID,
tblRptLineGroupXref.RptLineID
FROM tblReportLineMap LEFT JOIN (tblProgramGroup RIGHT JOIN
tblRptLineGroupXref ON tblProgramGroup.progGroupID =
tblRptLineGroupXref.RptGrpID) ON tblReportLineMap.RptLineID =
tblRptLineGroupXref.RptLineID

Thanks in advance
 
Top