Richard The problem is that I am dealing with two different databases .. Paul Lowman >You could always use direct SQL > >Insert into table xyz select blah blah from pqr where criteria met > >This syntax is valid in InterBase and has been since 5.x at least so it >should work in Firebird...