Creating a script trigger to enter data
I am trying to create a script that will enter in a doctor's information (last name, first name, address, ph, fax, etc) into their respective fields when I click into the MD last name field. In a related table to the patients' data, are over 1400 referring doctors so I want my administrators to be able to easily find the referring MD without having to enter in all their information over again.
I understand I need to specify a script trigger, but I am having trouble figuring out what the script should be. Also, once I have performed the find for the script and found the correct referring MD, I am unsure on how to have that data get automatically inserted into the respective fields.
Thank you for your help,