The query below is how far I've gotten.
Create Trigger TotalTrig after update on InvoiceLine Referencing InvoiceLine row as old new row as new for each row when (new.Unitprice != old.Unitprice or new.Quantity != old.Quantity) Update Invoice.Total;
I keep getting an error near the referencing InvoiceLine, for reasons I do not know.
Any guidance would be much appreciated! Thanks.