PhilPPhillips
MIS
I've never created a trigger and need some help.
I have an inventory location table (iminvloc). Everytime a new record is inserted into this table for location "20V", I'd like to insert a duplicate record in the same table, except for the location field, for every location defined in another table (called imlocfil).
I hope this makes sense. Any help would be appreciated.
I have an inventory location table (iminvloc). Everytime a new record is inserted into this table for location "20V", I'd like to insert a duplicate record in the same table, except for the location field, for every location defined in another table (called imlocfil).
I hope this makes sense. Any help would be appreciated.