Copying one Record into a new Record
Posted on 2012-09-13
I have a small Access database that i use in a shop for creating orders which are placed over the Christmas period.
Every time a customer places an order, i obviously manually enter this into the database. However, because this is for Christmas food orders, i very often get "Can i have the same as last year?" What this means is that i have to use one of my pre-made queries to search for all the customers previous orders and then write down the food order they placed the previous year, then create a new order and re-enter this info. What would save a huge amount of time is if i was able to select the order made in the previous year and just (preferably using a command button with some VB behind it) paste it into a new record, creating a new order. Is this possible at all.
I have several tables in the database. One is for customer details, one is for a list of products and another stores details on the order, such as customer ID, Product ID, order date etc.
Whats my best way of achieving this?