See Ron de Bruin's site. He has sample code for situations similar to this.

http://www.rondebruin.nl/tips.htm

more specifically probably a modification of one of these:

http://www.rondebruin.nl/copy5.htm

--
Regards,
Tom Ogilvy

"Alvaro Silva" wrote in message
...
I got a databse with about 200 registers and another with about 9,000.
both
are linked by the same lot number with one having qty and the second all
regiasters available for every particular lot. I need to update data in
the
second database with data from the first one. for the Quantity of
registers
of the lot number indicated in a given field in the first database.

Could anyone give advice how to set up a macro for that.

Alvaro Silva