Hi everyone,
I can't edit the title now, it's supposed to say "copying one TABLE to another", oops [note: title changed now - moderator]
I'll try to explain what I'm looking for as best I can but do please ask questions if I've done a terrible job of it.
To give some background, I run a daily download of fault tickets and I have the below tables set up
Old data
Current data
New data
I'd like to do the below in this order
1) Copy "Current data" to "Old data" (so Old is like an archive).
2) Append "New Data" to "Current Data" AND hopefully at same time, update other entries in "Current Data if they've been updated) - There is a field named "Last Updated" so it'll add anything brand new since the newest one, and then also update any tickets already in there with the updated information.
Is this at all possibl or will I need to do this as entirely seperate options?
Thanks in advance for your help, I really appreciate you taking the time to read this.
I can't edit the title now, it's supposed to say "copying one TABLE to another", oops [note: title changed now - moderator]
I'll try to explain what I'm looking for as best I can but do please ask questions if I've done a terrible job of it.
To give some background, I run a daily download of fault tickets and I have the below tables set up
Old data
Current data
New data
I'd like to do the below in this order
1) Copy "Current data" to "Old data" (so Old is like an archive).
2) Append "New Data" to "Current Data" AND hopefully at same time, update other entries in "Current Data if they've been updated) - There is a field named "Last Updated" so it'll add anything brand new since the newest one, and then also update any tickets already in there with the updated information.
Is this at all possibl or will I need to do this as entirely seperate options?
Thanks in advance for your help, I really appreciate you taking the time to read this.
Last edited by a moderator: