Hi Antares686,

thanx for replying..

i pass an id to the trigger,

the trigger then queries the db to populate its the fields.

i.e

******************************************************

TRIGGER trigger1...