Okay. All of the orders are in your database, correct? 1. Write a query that selects all of the days orders from 12:00am-11:59pm. 2. Create a form for the specific data and layout you want in your packing slip. 3. In your loop for each record, send the data to a printer. 4. For your electronic copy you could: 4a. Leave the data as it is in your DB and just populate the slip upon request. 4b. Inside the loop add a query to save only the slip data to a new table. Since you already have all of the data it really shouldn't be very hard to pull it out, populate your form, send each form to a printer, and populate an electronic form on demand based on the input of an order number. On 7/5/07, Jay Blanchard <jblanchard@xxxxxxxxxx> wrote:
PROBLEM I need to automatically create packing lists at the end of each day for items ordered through our warehouse inventory control system. Each packing list is related to a retail location. The packing list must be printed so that order pickers can get the materials and package for shipment to the locations. Each packing list must be archived electronically. RESOURCES Data from the inventory control system and the retail location database. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php