HI,
I’m trying to create an access database that will function like a file I created in Excel.
The object is when the user selects an “MP” from the dropdown this action will populate the related data that is
Shade with “Green”.
When the “Provider” is selected this action will also look for the “Patients” that this provider has.
When you select the dropdown for the “Patient Name” you will be able to see all of the Patients for this provider.
When you select the “Patients Name” this action will look at the “Patients Record” and the populate all of the data filed that is highlighted in “Red”.
You will note that I’ll be expanding this as you will notice the command buttons on the Form.
I would appreciate any help with this.
Charles