Hello I trying to learn access I am actually taking a class for I had to do an assignment but I am stuck in creating a relationship I get error and don't know how to fix them. Would someone show me what I doing wrong thanks. Primary key on DepartmentName
I got in table one DepartmentName, Budgetcode, Officenumber, and phone
Primary key on Employee Number
On the other one EmployeeNumber, FirstName, LastName, Department, phone, Email.
I keep getting Error 3201 you cannot add or change a record because a related record is required in table (name)
Can someone tell how can I create a relationship