By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,701 Members | 1,970 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,701 IT Pros & Developers. It's quick & easy.

Need to "Copy PO" - duplicate record with main and subform

P: 3
I have been trying to create a purchase order database in Access, and I have been successful in creating all the tables, queries and reports that I need. I have only one issue: I need to copy the PO - which has a relationship set up as one-to-many with a subform that includes the PO items (Qty, Desc & Price). I want to be able to create a duplicate record using a simple command button, that not only duplicates the main record, but includes all the PO items in the subform in the new duplicated record. Not sure how to proceed.
Apr 14 '07 #1
Share this Question
Share on Google+
3 Replies


P: 49
I have been trying to create a purchase order database in Access, and I have been successful in creating all the tables, queries and reports that I need. I have only one issue: I need to copy the PO - which has a relationship set up as one-to-many with a subform that includes the PO items (Qty, Desc & Price). I want to be able to create a duplicate record using a simple command button, that not only duplicates the main record, but includes all the PO items in the subform in the new duplicated record. Not sure how to proceed.

Why are you duplicating??? Surely that is against DB protocol?

what is the reason ? there may be other ways to give that same functionality
Apr 14 '07 #2

P: 3
Why are you duplicating??? Surely that is against DB protocol?

what is the reason ? there may be other ways to give that same functionality
I need to copy the PO, then edit - so that PO's with many entries in the ITEM ENTRY subform will be copied as well, the new PO# will be assigned and then I can edit the required date, Vendor, etc. Will save data entry time with a new similar PO.
Apr 16 '07 #3

Denburt
Expert 100+
P: 1,356
I once had a similar request, I found an article here that might help you on your way. If you run into problems with it feel free to ask.

http://support.microsoft.com/kb/210236
Apr 16 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.