Need Pulldown Provider Names

Question

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.
------------------------------

BobThomas1 · Answer

I believe I have figured out the answer. I set up a relationship between the Encounters Table (child table) & the prvdrfullnmes (parent table). I then used the provider name in the prvdrfullnmes as a lookup field, so that in the Encounters table the prvdrfullnme is pulled from the prvdrfullnmes table. No I have to do the same in a NoShows table, which I will try tomorrow.

This makes for cleaner data, the provider name will be only in one table and additions to the provider table is in that table.

More to tweak in the App, but it's a big start for me.

------------------------------
Bob T.
------------------------------

Sign up

Login to the community