I'm trying to rewrite queries for better performance and am stuck on one.
This is how it is written now:
SELECT tbl_OrderParts.UniqueID, tbl_OrderParts.Part_Number,
tbl_OrderParts.Sales_Order, tbl_parts.Product_Description, tbl_parts.ECCN,
tbl_parts.Manufacturer_ID, tbl_manufacturer.Manufacturer
FROM tbl_manufacturer INNER JOIN (tbl_parts INNER JOIN tbl_OrderParts ON
tbl_parts.Part_Number = tbl_OrderParts.Part_Number) ON
tbl_manufacturer.Manufacturer_ID = tbl_parts.Manufacturer_ID;

I rewrote it as follows but now it's not updatable (does not allow entry in
my form):
SELECT tbl_OrderParts.UniqueID, tbl_OrderParts.Part_Number,
tbl_OrderParts.Sales_Order, tbl_parts.Product_Description, tbl_parts.ECCN,
tbl_parts.Manufacturer_ID, tbl_manufacturer.Manufacturer
FROM tbl_manufacturer, tbl_parts, tbl_OrderParts
WHERE (((tbl_parts.Part_Number)=[tbl_OrderParts].[Part_Number]) AND
((tbl_manufacturer.Manufacturer_ID)=[tbl_parts].[Manufacturer_ID]));

Where have I gone wrong? The first query is super slow and thought I should
revisit using the Inner Joins...