Updateable query

[rustersen]

Hi all,

I'm trying to make an updatable query for a partsorder form, but im having trouble.

I think its due to having to many inner joins, but is there a way to make this work:

SELECT DISTINCTROW WoJobTbl.JobItemNo, PartsOrder.OrderPriority
FROM ((EstimateTbl INNER JOIN WoJobTbl ON EstimateTbl.ProjectID = WoJobTbl.ProjectID)
INNER JOIN EstimateJobTbl ON EstimateTbl.EstimateId = EstimateJobTbl.EstimateId)
INNER JOIN (EstimatePartTbl LEFT JOIN PartsOrder ON EstimatePartTbl.EstimatePartId = PartsOrder.EstimatePartId)
ON EstimateJobTbl.JobId = EstimatePartTbl.JobId;

 

[Guus2005]

Remove DISTINCTROW.

It might still be impossible to edit the rows this query produces.

HTH