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,