•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 391,146 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,155 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser:
Views: 2074 | Replies: 0
 |
•
•
Join Date: Jun 2006
Posts: 67
Reputation: 
Rep Power: 3
Solved Threads: 9
Junior Poster in Training
I have a Access 2003 database which has a table we'll call orders.
There are 10 other tables linked to orders through Order_ID.
I'd like to be able to create a duplicate of a record and all the associated records in the linked tables.
I've read it possible with an append query, but I'm wondering if there is a way to filter a recordset and then append the recordset back to the original table. 11 recordsets, 11 filters and 11 appends as opposed to 1 huge dirty query which would be harder to debug in my opinion but i'm more than open to advice and options here.
There are 10 other tables linked to orders through Order_ID.
I'd like to be able to create a duplicate of a record and all the associated records in the linked tables.
I've read it possible with an append query, but I'm wondering if there is a way to filter a recordset and then append the recordset back to the original table. 11 recordsets, 11 filters and 11 appends as opposed to 1 huge dirty query which would be harder to debug in my opinion but i'm more than open to advice and options here.
------------------------------------------------------------
ConnectNL Directory | NLTourist | Free eLearing Courses
ConnectNL Directory | NLTourist | Free eLearing Courses
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
Linear Mode
- how to delete duplicate record in a table by using SQL query (MS SQL)
- how to delete duplicate record... (C++)
- Delete related record (VB.NET)
- need to update each records after record deleted (PHP)
- Giving records in MS Access unique numbers (MS Access and FileMaker Pro)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Access 2007 Validation Rule Error
- Next Thread: please help how to display records
