I'm VERY new to this and I have scoured the web to try to find this answer and I haven't gotten even close so here I am!
Here's the context. We're a online health education platform and we're collecting data from our clients to educate them about healthier ways of being, etc.
What we're trying to do right now:
I'm trying to make an Educator portal which would allow an Educator to see data from a specific Member.
I want to create a drop down menu linked to a database. In this drop down I want only the clients the Educator is working with to show up, so this will have to be a limited list.
Once the Educator chooses that member, I want their data to populate from another form, preferably an external database, but for now we can do internal if that's easier.
Can someone help me, please? I know there's a lot of steps to this so ANY help is greatly appreciated.