I am not sure about the code you wrote , but one simple way to solve the problem fast is 1- write the code to get the data from the 1st table and print it on the screen, to make sure that the data is complete and correct 2- Now write a code to insert data on the second database and test it independantely ; to make sure that the insert is Ok! 3- Now form one procedure from the two parts you created in point 1 and 2 NOTE : be aware about the constraints , primary keys , and referencing to other tables [You may want to delete the row from the original table and try to write it back to its original place using the same code you use to insert on the second database ; this will make you sure that there is no problem with the new code ] Important : USE ONLY YOUR TEST TABLES NOT THE ORIGINAL ONES YOU DEPEND ON FOR YOUR BUSENESS OR SO. and have packups all the time --BelloSoft

Thank you :rose: ! I will try the first solution :~

I have a very big view (i.e. city) with so many detailes on it, and it consumes time to draw/redraw it. My problem is: :((to select a street from that city, I have to ReDraw the scene/the whole city to do the picking and see the detailes of that street. Does any one know how to do the selection / picking without redrawing every thing ? :rose:Thank you