AnsweredAssumed Answered

Need help A Copy Script

Question asked by JoeKantoski on Sep 12, 2011
Latest reply on Sep 12, 2011 by JoeKantoski


Need help A Copy Script


I have been at it for several days now and can't figure out the best way to do what I want to so I reaching out for a little help. I also know that this might be a little bit of a data duplication but it necessary becuase it is for medical forms and I need to duplicate data.


What I am failing to accomplish is create a script that will copy  all of the records based on a fk and a pk out of one table and paste them into another table. Basically i set the main table up to have a patient number and this also creates a auto generated key because there could be more than one patient number.

I want to copy all of a certain patient and paste in a second table.  I would prefer not to use actual copy and paste commands. I was not sure if needed a loop with the set fields or something along those lines. If someone could guide me in the right direction that would be great,