thank you for your previous reply.
today i have one more task to finish.
the problem is that
we have an invoice table with fields ( invoice_id,date , item_id,item_na me, price_per_item, quantity,cust_i d)
here (item_id ,item_name and price_per_item) are from table item_details.
now i have to write a trigger to track the users who have changed the price_per_item column before insertion in invoice table.
please help me
today i have one more task to finish.
the problem is that
we have an invoice table with fields ( invoice_id,date , item_id,item_na me, price_per_item, quantity,cust_i d)
here (item_id ,item_name and price_per_item) are from table item_details.
now i have to write a trigger to track the users who have changed the price_per_item column before insertion in invoice table.
please help me