Forum Discussion

BobThomas1's avatar
BobThomas1
Qrew Cadet
3 years ago

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.
------------------------------
Relationships
  • BobThomas1's avatar
    BobThomas1
    Qrew Cadet
    3 years ago
    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.
    ------------------------------
    • DonLarson's avatar
      DonLarson
      Qrew Elite
      3 years ago
      You got it.

      ------------------------------
      Don Larson
      ------------------------------