Hi,
I do not know if I'm failing to see what your telling me. I created the table for the "Patients name only". But am failing to see how this will help me when I select the "Provider" from the Providers combobox in the form and have "Patients Combo" only display the Patient Name (once) from the table for "Patient Record"(listed multiple times) and (not the new table I created). The field "Patient Name" in the table for the " Patients Records" will have the same name listed several times for the provider selected. My goal is not to have the "Patients" combobox show duplicate names. In Excel I have a code to populate the combobox without duplicate names.
So as you can see I'm still confused using Access.
Charles