Hi i have a view that contains:
ITEMID ITEMNAME STATUS
1001 BRICKS 1
And the table is updatated to:
ITEMID ITEMNAME STATUS
1001 BRICKS1111 1
and i want that status automaticaly would change to 0 when update/insert is made (it can be made from ERP software)