DJ,

I think this maybe helpful for others too..

OK.. Let's break this down..

It seems that you have created the needed tables in SQL. However, when you run the script, it does not update or change any data in the tables?

Have you tried to debug the script at all?

We did some work in the thread: Re- Inventory Management

Anyway, when I get into work.. I can post it for you as it works great.. It looks like something maybe up with your dbconnection.

Kent
_________________________
Utilize these resources:
UDFs (Full List)
KiXtart FAQ & How to's