I "moved" a field from one table to another. Need to copy values

Discussion created by bryanade on Mar 1, 2017
Latest reply on Mar 1, 2017 by Stephen Huston

In my DB, I had patient weight in the Patient table, but we are actually interested in the weight of the patient on their visit dates (so there's possibly more than one weight per patient). I've created the new variable in the Visit table, but now need to copy the already entered weights from the Patient table to the Visit table. The two tables are linked in Relationships, but also there are two unique identifying numbers that can be used to verify patients. Would I do this through a script that I run just once?