Recent content by froot loops

It's ok no rush. It's not due until next week. thank you for all ur help so far Also when u added the primary key for both the course and programs table. My primary key has to CourseNumber for course table and ProgramID can't be auto number because the program id's have there own code like...

it won't let me. it will just add more records to the professor form. I get a msg about the fields for the data i tried to paste don't match the fields on the form than it asked if i wanted to paste the fields only with the same name

ok thank you Onto my next question Now i can create subforms with a main form I have professor as the main form and courses as a subform but the subform is not populated. I have to enter the info myself? The relationship is established so that means i have multiple courses taught by one prof.

Thank you What was my problem? Like what did i do wrong? For the program table i can't use my orignal primary key? u can't have an autonumber data type with a number datatype? I know it has the be same but they are both numbers

I change programid field number data type and added a CourseNumber field to professor table. But that does not implement some of the require situtations. Like say two professors teach the same course.

thank you i didn't catch that but still i can't create a relationship between prof and courses table

Hi I started access and i can't seem to get the relationships working. i have three tables table one professorID (primary) other fields table two CourseNumber(foreign) Other fields table three ProgramID (foreign) other fields I have established a one to many relationship between courses...