I have two tables 1) ToysBox 2)Toys
ToyAssignmentStatus 'N' (when an entry is made status is assigned N (which is not assigneD)
Toy_assignment_status "N" is default (ie NOT ASSIGNED)
(when Toy is assigned to a wearhouse its status changes to A Or when toy is missing in a box its status is changed to 'M')
I want to write a Trigger which fires when all toys are assigned for a particular BoxID
We need to check in toys table if toy_assignment_status is not "N" for the particular TOYBOXID and
Udpate todays date in ToyBoxcloseDate Column in ToysBox table.(this indicates that a ToyBox has been closed)
Pls help me with this.