G
Guest
Hello guys,
I am in a pickle, we made some changes to our db, most of them fixes to
forms and reports, but I did add/delete some idexes. But all the sudden one
form we have, which allowed the user to edit changed to non-updatable. The
only change I can see that would effect this is the indexes, how I'm really
not sure. The query is below, any insight would be a godsend, I am stumped!
SELECT tblBatchs.BatchID, tblOrders.OrderID, tblOrders.ProductionOrder,
tblPreliminaryReportData.ReportSortOrder, tblOrderDetails.ItemNo,
tblOrderDetails.ProductID, qryProducts.ExportToCutrite, qryProducts.UserCode,
tblOrderDetails.Modification_1, tblOrderDetails.ModExports_1,
tblOrderDetails.ModTempExports_1, tblOrderDetails.Modification_2,
tblOrderDetails.ModExports_2, tblOrderDetails.ModTempExports_2,
tblOrderDetails.Modification_3, tblOrderDetails.ModExports_3,
tblOrderDetails.ModTempExports_3, tblOrderDetails.Modification_4,
tblOrderDetails.ModExports_4, tblOrderDetails.ModTempExports_4,
tblOrderDetails.OrderDetailID, tblOrderDetails.RemoveCase,
tblOrderDetails.detFSLocation
FROM tblBatchs INNER JOIN (tblOrders INNER JOIN ((qryProducts INNER JOIN
tblOrderDetails ON qryProducts.ProductID = tblOrderDetails.ProductID) INNER
JOIN tblPreliminaryReportData ON tblOrderDetails.OrderDetailID =
tblPreliminaryReportData.OrderDetailID) ON tblOrders.OrderID =
tblOrderDetails.OrderID) ON tblBatchs.BatchID = tblOrders.BatchID
WHERE (((qryProducts.ExportToCutrite)=True) AND
((tblOrderDetails.Modification_1) Is Not Null And
(tblOrderDetails.Modification_1)<>"" And (tblOrderDetails.Modification_1)<>"
") AND ((tblOrderDetails.ModExports_1)=False) AND
((tblOrderDetails.RemoveCase)=False)) OR
(((qryProducts.ExportToCutrite)=True) AND ((tblOrderDetails.Modification_2)
Is Not Null And (tblOrderDetails.Modification_2)<>"" And
(tblOrderDetails.Modification_2)<>" ") AND
((tblOrderDetails.ModExports_2)=False) AND
((tblOrderDetails.RemoveCase)=False)) OR
(((qryProducts.ExportToCutrite)=True) AND ((tblOrderDetails.Modification_3)
Is Not Null And (tblOrderDetails.Modification_3)<>"" And
(tblOrderDetails.Modification_3)<>" ") AND
((tblOrderDetails.ModExports_3)=False) AND
((tblOrderDetails.RemoveCase)=False)) OR
(((qryProducts.ExportToCutrite)=True) AND ((tblOrderDetails.Modification_4)
Is Not Null And (tblOrderDetails.Modification_4)<>"" And
(tblOrderDetails.Modification_4)<>" ") AND
((tblOrderDetails.ModExports_4)=False) AND
((tblOrderDetails.RemoveCase)=False))
ORDER BY tblOrders.ProductionOrder, tblPreliminaryReportData.ReportSortOrder;
Thanks Rick
I am in a pickle, we made some changes to our db, most of them fixes to
forms and reports, but I did add/delete some idexes. But all the sudden one
form we have, which allowed the user to edit changed to non-updatable. The
only change I can see that would effect this is the indexes, how I'm really
not sure. The query is below, any insight would be a godsend, I am stumped!
SELECT tblBatchs.BatchID, tblOrders.OrderID, tblOrders.ProductionOrder,
tblPreliminaryReportData.ReportSortOrder, tblOrderDetails.ItemNo,
tblOrderDetails.ProductID, qryProducts.ExportToCutrite, qryProducts.UserCode,
tblOrderDetails.Modification_1, tblOrderDetails.ModExports_1,
tblOrderDetails.ModTempExports_1, tblOrderDetails.Modification_2,
tblOrderDetails.ModExports_2, tblOrderDetails.ModTempExports_2,
tblOrderDetails.Modification_3, tblOrderDetails.ModExports_3,
tblOrderDetails.ModTempExports_3, tblOrderDetails.Modification_4,
tblOrderDetails.ModExports_4, tblOrderDetails.ModTempExports_4,
tblOrderDetails.OrderDetailID, tblOrderDetails.RemoveCase,
tblOrderDetails.detFSLocation
FROM tblBatchs INNER JOIN (tblOrders INNER JOIN ((qryProducts INNER JOIN
tblOrderDetails ON qryProducts.ProductID = tblOrderDetails.ProductID) INNER
JOIN tblPreliminaryReportData ON tblOrderDetails.OrderDetailID =
tblPreliminaryReportData.OrderDetailID) ON tblOrders.OrderID =
tblOrderDetails.OrderID) ON tblBatchs.BatchID = tblOrders.BatchID
WHERE (((qryProducts.ExportToCutrite)=True) AND
((tblOrderDetails.Modification_1) Is Not Null And
(tblOrderDetails.Modification_1)<>"" And (tblOrderDetails.Modification_1)<>"
") AND ((tblOrderDetails.ModExports_1)=False) AND
((tblOrderDetails.RemoveCase)=False)) OR
(((qryProducts.ExportToCutrite)=True) AND ((tblOrderDetails.Modification_2)
Is Not Null And (tblOrderDetails.Modification_2)<>"" And
(tblOrderDetails.Modification_2)<>" ") AND
((tblOrderDetails.ModExports_2)=False) AND
((tblOrderDetails.RemoveCase)=False)) OR
(((qryProducts.ExportToCutrite)=True) AND ((tblOrderDetails.Modification_3)
Is Not Null And (tblOrderDetails.Modification_3)<>"" And
(tblOrderDetails.Modification_3)<>" ") AND
((tblOrderDetails.ModExports_3)=False) AND
((tblOrderDetails.RemoveCase)=False)) OR
(((qryProducts.ExportToCutrite)=True) AND ((tblOrderDetails.Modification_4)
Is Not Null And (tblOrderDetails.Modification_4)<>"" And
(tblOrderDetails.Modification_4)<>" ") AND
((tblOrderDetails.ModExports_4)=False) AND
((tblOrderDetails.RemoveCase)=False))
ORDER BY tblOrders.ProductionOrder, tblPreliminaryReportData.ReportSortOrder;
Thanks Rick