query join help

[jwrocko]

I have a query that produces the desired results, but I need to be able to edit the results. So, the query is form resource.

SELECT  Parts.Part_Number, Parts.Component, Part_Detail.Manufacture_From, Part_Detail.Manufacturer, Part_Detail.Vendor_Part_Number, Parts.[Tracked?], Part_Detail.Vendor, Part_Detail.Unit_Cost, Parts.[Assembly?], Corellation.[RPL?]
FROM Parts, Part_Detail, [temporary], Corellation
WHERE (((Parts.Part_Number)=[temporary].[Part_Number]));

I am using this form to edit part information.

temporary.part_number holds a part number that inserted by the user to specify which part will be edited. The part number itself will not be edited. Everything else will be.

 

[fneily]

You might want to read:
Harnessing the Power of Updatable Queries

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccess/html/msdn_harness.asp