I'm with Jack on this one, we need more information. However if the problem you are trying to solve is that you want to display some information from the inspection table and a query is not cutting it, then what I've done in the past is create a Form in datasheet view and use a combo box as a substitute for a step in a query. Now you have an underlying query for the form, (which you display in datasheet view) and the form contains a combobox which in itself contains another query.Normally you wouldn't, but this arrangement is greatly complicating my queries
Right - this sounds like it's worth trying.There is also the idea that if you add the extra field to the third table but DO NOT add a permanent relationship, you can build a query using the query design grid. When you drop the first and third tables into the graphics area above the query grid, you can draw a TEMPORARY relationship that avoids the confusion of having that 2nd table in the way. That way you could avoid having a permanent anomalous relationship that would be caused by having both a direct and an indirect path from table 1 to table 3.
UPDATE tblErrorDetails INNER JOIN tblSampleDetails ON tblErrorDetails.[Sample ID] = tblSampleDetails.[Sample ID] SET tblErrorDetails.[InspectionIDcopy] = tblSampleDetails.[Inspection ID]