SS, I have tried, changed a bit in the table name;

WHERE inv.InventQty < 150 (before you put as ins.InventQty) I specificly lower one product quantity to 100

then...

Thanks so much SS!

but do I need to assign a value to the POrdID?

but ss eight,

I do not understand, why do you select 600, it is only a value set up, it is the value I want to insert into the row.

Thanks

Thank for reply, I'll test it out and let you know.