BobThomas1
3 years agoQrew Cadet
Need Pulldown Provider Names
I'm working on a patient encounter table. A physician name is populated in this field. As you can see from the form, you can put in any name as I have for Dr. Benjamin Spock. The format used is last name, first name. The Provider Full Name table (prvdrfullnmes are all capitalized) names have been set in some other table, I believe, so I can't add any there at present. BUT the I want the provider names in the Encounters table to ONLY come from the names in the prvdrfullnmes table.
How do I go about this?
------------------------------
Bob T.
------------------------------