Hi again. Just thought Id ask this question I need to create a trigger to reduce the quantity in stock when a part appears in the invoice line, Ive tried loads of things only to get error after error The tables which i need to use in the trigger are these:
I have an invoice line table which has these fields: Invoicenumber, Date, PartNumber
And a Part Table with these fields: PartNumber, qtyinstock, minstock, description
I need a trigger to reduce the number in stock on the part table when the part number appers in the invoice table, hope you get me
Any help or bits of Trigger statements would really help.
I have an invoice line table which has these fields: Invoicenumber, Date, PartNumber
And a Part Table with these fields: PartNumber, qtyinstock, minstock, description
I need a trigger to reduce the number in stock on the part table when the part number appers in the invoice table, hope you get me
Any help or bits of Trigger statements would really help.