Hello All,
I am in the process of creating a database to cover the purchases of various people within a group. I have two tables - one for orders (vendor, date, order number, person who ordered, some shipping info) and one for the items and their costs ordered within each order - the tables are related by the order number. I have a form to enter the order info with a subform for the items. So far so good.
The problem is that sometimes a single order is for two people - ie. Bob and Joe both needed something from Vendor X, so they ordered together to save on the shipping, but now some of the items in the order should be charged to Bob and some to Joe. I recognize that this must require two separate entries in the order table, but much of the order info is actually identical and things like long order numbers are tedious to re-enter correctly. Is there code for a button that would create a new record and duplicate some of the order info if desired? The only references I can find online are options to duplicate fields every single time you create a new record, which doesn't make sense here. I tried just duplicating the whole record but that led to mistakes when important fields were not changed.
Thanks for any insight anyone has!
I am in the process of creating a database to cover the purchases of various people within a group. I have two tables - one for orders (vendor, date, order number, person who ordered, some shipping info) and one for the items and their costs ordered within each order - the tables are related by the order number. I have a form to enter the order info with a subform for the items. So far so good.
The problem is that sometimes a single order is for two people - ie. Bob and Joe both needed something from Vendor X, so they ordered together to save on the shipping, but now some of the items in the order should be charged to Bob and some to Joe. I recognize that this must require two separate entries in the order table, but much of the order info is actually identical and things like long order numbers are tedious to re-enter correctly. Is there code for a button that would create a new record and duplicate some of the order info if desired? The only references I can find online are options to duplicate fields every single time you create a new record, which doesn't make sense here. I tried just duplicating the whole record but that led to mistakes when important fields were not changed.
Thanks for any insight anyone has!