If you are recording that a patient has different doctors at different times, you should have three tables. Your design may be wrong.
I have asked the moderator how to send you my email address. I'd be very happy to help you out. I used to do lots of Access dbs but have now moved to Belgium - and I'm BORED!