Subform troubles

[whojstall11]

My subform it wont let me enter in multiple data im pretty sure its many to many but not sure how to change it.

 

[boblarson]

I wouldn't use TEXT for my primary key and foreign keys, but since you are - you need to make these changes.

Your relationships are honked. They currently look like this:

You do not link all of the fields to the MRN.

Second, your MEDICATIONS table is messed up.

Then you fix your relationships:

 

[whojstall11]

Omgggggggggggggggg thank you