INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Appending 2 related tables to 2 new tables

Appending 2 related tables to 2 new tables

(OP)
I have a small database on a SharePoint site. I created 2 new tables - Orders and OrderDetails. The database is now working online, but I need to append Orders and OrderDetails from the original stand alone database for history. How can I append the data in the old tables and keep the relationships between the orders and the details?

RE: Appending 2 related tables to 2 new tables

Can you please list the fields for each table and any keys between them? Are they separate access databases? One way would be to link the tables from the online db to the archive db, and in the archive db, you can create a method (Append Query) to append where all fields are not the same, or the key field doesn't yet exist. If this was in SQL, you could run a trigger to manage this, or a job to run daily.

My question is why you need to copy data from one place to another. Is this to keep an audit trail history or what was on the site at a given time, vs right now?

misscrf

It is never too late to become what you could have been ~ George Eliot

RE: Appending 2 related tables to 2 new tables

(OP)
Thank you. I was able to figure this out a couple of months ago.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close