Relationships amongst tables

[mt212324]

I am building a small database and I am having trouble with the relationships. I have most of them setup but 3 different ones I can't seem to get.

Student
PK Student ID

Trying to make this one be many to one with this one

Student_Grade
PK Student_ID

The other one is

Instructor
PK Instructor_ID

Connecting to

Approved_Instructor
PK Instructor ID

And then connecting

Approved_Instructor
PK Instructor ID

to

Class
Instructor_ID

Thanks for any help

 

[Trevor G]

Welcome to the forum,

Although you are giving the field names in your thread it would be easier if you can post a copy of your database, even if it is stripped down, that way it will be easier to identify the issue.

I can't see what data types you are using.