I have your standard customer, order, and order details database. In tblOrders, I have the the shipping address information. The reason it is in orders, a few clients can ship to different addresses and we need to track all orders and the shipping info. Here is what the boss wants. When a new order is placed for an existing customer, we need the customers previous order's shipping address to automaticly populate the new order's shipping address. I just can't seem to get it worked out in my head.