Need help creating simple Patient/Doctor database.

[RuralGuy]

You are just using queries and their Datasheet view. How did you want to select the Dr.? If you put = "Dr. Joe" in the Criteria row of the design view of the query it will add the WHERE clause to your query.

[RuralGuy]

It needs to match your [Doctor] field value exactly. You may find you have selected a ForeignKey field of a table which should contain the PrimaryKey (PK) value of the Doctor and not their name.

[RuralGuy]

BTW, here's a good reference site and some words of wisdom for designers: http://access.mvps.org/access/tencommandments.htm

[Oppogo]

I figured out the query thing, didnt notice this post had page 2 so i have been editing my recent post.

Anyway, I still cant manage to allow patients to choose multiple illnesses as it breaks the relationship for some reason and then nothing displays under doctors anymore. Any ideas?

[RuralGuy]

Each illness is probably a separate record in the illness table right? I'm not sure I understand when you say "it breaks the relationship"!

[Oppogo]

Yes, each illness is a seperate entry, on patients table it's a dropdown box with checkboxes. If i create the dropdown box so it allows multiple values (multiple checks), i am forced to remove my relationship between illness and illness ID (the relationship image), after i have changed it to be multiple choice, i replicate the relationship again, however it doesnt work as it did with single choice, any checks made do not appear on doctor patient subtable (Doctors table in image), The + icon as it is disappears alltogether. It may be my limited knowledge, i cannot fix that.

[RuralGuy]

Can you describe what you think it *should* look like with multiple illnesses? Are you trying to view more than one patient? More than one Doctor?

[RuralGuy]

There are limitations to the Datasheet view in Access but it is not an Access limitation, just the Datasheet view. You would be surprised at what you can do with a Form. Were you planning on just using the built in display features of Access and not building a form?

[Oppogo]

It's not that i want to view anything, i want to input a patient, lets say July, she has a headache and a toothache, i can't do that since i can only input a single illness. Once i make it that i can input multiple, it breaks my database altogether. I don't know how to explain it, i could just add another dropdown menu, it's not really that big of a deal, was just wondering why that happens

[RuralGuy]

Well I'm sorry but I cannot explain the results you are getting. As I asked before, are you NOT going to create any Forms, just use the built in facilities of native Access?

[RuralGuy]

Is this a class assignment of some kind?

[Oppogo]

You could say that, however the teacher doesnt even run over these things. We are just told to make a database and that's it, not rly much to go from. Anyway, i would consider this good enough for my needs, thanks for all the helping tips.

[RuralGuy]

I'll go ahead and mark this thread a Solved for you and you're very welcome.