Hello I use a database to track orders for a delivery business. The heart of the database is entering of orders in which 2 tables are used. An "orders" table which contains the customers name, the ship date and the order# (auto-number) and the "ordersdetail" table that contains the product and and quantity. The tables are bound by the order#.

I have customers with standing orders that are the same everyday. I would like to create a macro to automatically enter these and just don't know where to begin.

Any help will be greatly appreciated.

Thank you.

BTW I am using Access2000