I have the following Query:
INSERT INTO Job_Materials ( Part_Number, Order_Number, [Lot Number], Tran_Date, [MFG Lot] )
SELECT [Enter Part Number:] AS Expr1, [Forms]![Reject_Record]![Order_Number] AS Expr2, [Enter Lot Number:] AS Expr3,
Date() AS Expr4, [Forms]![Reject_Record]![userchar2] AS Expr5;
Basically whats going on is the user clicks a button on a form, which runs this "add part" query. The query obtains values from the current form (Order Number and MFG Lot) as well as values that are prompted for entry by the user (Part Number and Lot Number).
What I cannot seem to figure out is:
This append query is updating an Access database table (Job_Material)
Bascially Expr1 from the query above = dbo_part.partnum (a different table value)
I would like this query to also update the Access database table (Job_Material) with the part description from (dbo_part.partdesc) based on the value entered by the user for Expr1.
This avoids the user entering the part descriptions manually.
How can I accomplish this?
Thanks