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...
Forum Discussion
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.
------------------------------
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.
------------------------------
- You got it.
------------------------------
Don Larson
------------------------------
