I have a table that is going to act as a stagging area between a SQL Server and my VFP app. SQL will deposite new records (Orders, Order Items and Location information) into my wbOBSin.dbf table. My VFP app needs to bring this information into my app (updating the Orders.dbf, OrderItems.dbf and Locations.dbf) for the users to process. I've already got this working manually via an "Import Next Item" command button on an Import form.

How can I automate this process so that my app will do this without the user?

TIA,
Rick