Kathy,

See my response to your previous post.

I think you want to try this instead:

DECLARE @varCust varchar(50), varAssy varchar(50)
SELECT @varCust = Customer,
@varAssy = Assy
FROM tblWorkOrders
WHERE WorkOrder = @varWO

UPDATE table
SET field = @varCust,
field2 = @varAssy
where somefield = somevalue

In fact, you could condense this to the following:

UPDATE table
SET field = tblWorkOrders.Customer,
field2 = tblWorkOrders.Assy
FROM tblWorkOrders
JOIN table ON tblWorkOrders.PK = table.FK
WHERE tblWorkOrders.WorkOrder = @varWO
AND otherconditions...

Hope this helps.

--
-Chuck Urwiler, MCSD, MCDBA
http://www.eps-software.com