Drop Down Option

Sandpiper

Registered User.
Local time
Today, 22:52
Joined
Feb 21, 2006
Messages
55
Apologies if this has been answered before.
I am an inexperienced Access Database writer who wants to learn more - so first question, are there any Access Gurus' near to Buckingham/Milton Keynes UK that would be willing to spend a couple of hours showing me advanced access programming with a specific databsae in mind (i have a more complicated one than the one attached to attempt) (paid of course).

Secondly, I have a form which I would like to finish this week and am struggling with. The main form is frm_PatientDetails. I am trying to add a subform frm_Practitioner which shows a drop down box of the practitioners names, but allows you to choose more than one. This is a many to many relationship as a patient can have more than one practitioner and a practitioner has more than one patient. I have had a go at creating a junction table, and a query, but got a feeling i'm doing it all wrong.
I've attached the database, so any other feedback on what i've done right and wrong would be much appreciated.
Thanks in advance for the help.
 

Attachments

Last edited:
Everything I know I learned from these forums. In my experience, the interactive help here is at least as good and usually better than anything you can be 'taught'.

Oh, and there's no attachment.
 
Thanks.
I've attached the file now. Not sure what happened last time.
 

Users who are viewing this thread

Back
Top Bottom