Thanks for the tip Wayne.

In trying to research and find a solution on my own, I read through A LOT of information about Views. I just want...

Thanks for your help Lutz, I really appreciate it.

I was able to create the View I need with your help and a couple of modifications. I've been working on...

Here's the statement I used to create the view. I'm not too familiar with the SQL needed to do things in one shot.

CREATE VIEW [dbo].[viewname]

AS

SELECT '' AS QtyTotal,...

Thanks Lutz.

Here is the update I've been trying to make...

UPDATE viewname

SET QtyTotal = SUM(QUANTITY)

WHERE SERIALNUM = SERIALNUM and RECEIPT = RECEIPT

and here is the error I receive...

"Msg 4406, Level 16,...

Thanks for your reply, John.

I just found out that I do not need to create an SP or a Trigger, by accident.

I am in a weird position here...

Thanks Lutz.

I'll give it a shot.