Hi
I have two databases- "Patient" (with Patient ID)and "Visit" ( With visit ID). Patient and visit files are connected through patient ID. One patient can have multiple visits, On a visit i enter a patients findings and labs etc. When that patient comes for a second visit, i want certain fields to be automatically filled. i tried writing a script with copy and paste but it will pick-up the data from the last record i was working on, which sometimes isnt the same patient. is there a way to write a script so that it will copy certain data from the same patient's last visit.
I have two databases- "Patient" (with Patient ID)and "Visit" ( With visit ID). Patient and visit files are connected through patient ID. One patient can have multiple visits, On a visit i enter a patients findings and labs etc. When that patient comes for a second visit, i want certain fields to be automatically filled. i tried writing a script with copy and paste but it will pick-up the data from the last record i was working on, which sometimes isnt the same patient. is there a way to write a script so that it will copy certain data from the same patient's last visit.