Trigger!

[johnvai]

Dear Friends:
I have this error message when updating from VB6.

"Table or view not found:correlation name 'Products' not found."

The trigger is on posdetail table after insert event.
the trigger code is:

alter trigger "dba".Poller after insert order 1
on "DBA".POSDETAIL
referencing new as new_posdetail
for each row
when(new_posdetail.price>0)
begin
if exists(select products.groupwith,products.prodlocid,posdetail.prodnum,posdetail.quan from products,posdetail where new_posdetail.prodnum=products.prodnum) then
if producs.groupwith>0 then
call pollstock(products.groupwith,products.prodlocid,new_posdetail.quan)
else
call pollstock(new_posdetail.prodnum,products.prodlocid,new_posdetail.quan)
end if
end if
end

any hints?