Trying to relearn access and running into a problem already

[finatrick]

I'm trying to get back into using access again after several years and I'm having trouble. In order to get reacquainted to the program, I'm following the steps from the Step-by-Step book by Microsoft I just stated and I'm already having issues and hope someone can help me. In the book, I am asked to create a relationship between three tables. I followed the steps to the T but referential is violated even though I change the field to what it is supposed to be according to the book.



For those not familiar with the book we I was asked to create an Employees, Customers and Orders table. The first two tables having one or two records(since I just started with the book) and the Orders table containing the foreign keys to each table. Long story short, when I try to enter the correct number that would reference the field in the employee table and try to leave, I get the integrity field error.

I've attached a word document of screenshots of the relationship and the tables along with the error.

I double tried this exercise and can't figure it out. Can someone help?

[redekopp]

I am assuming its a field join issue, I tried it with and without checking enforce referential integrity, and making the join type 2 for both from customers > orders and employees > orders. Seems to work.

Give that a try.

[finatrick]

Thank you for the quick reply redekopp. I did what you suggested bye removing referential integrity and I was able to enter the number that points to the correct employedd id. Thnk you for that. However, isn't unchecking referential integrity problematic and can cause issues down the road?

[finatrick]

Thank you for the quick reply redekopp. I did what you suggested bye removing referential integrity and I was able to enter the number that points to the correct employedd id. Thnk you for that. However, isn't unchecking referential integrity problematic and can cause issues down the road?

For instance, I was able to enter the correct value(1) but I was able to enter 11 which was also accepted. In the book I was told in the step to enter 11 in order to show the use of checking the integrity box. Given the current database size I'm working with unchecking might not by an issue but I can see how checking that box can be useful when working with larger databases.

[pbaldy]

Your picture shows a 0 in the employee field; was that the value you tried to use? If so, did it exist in the employee table? The error implies that whatever value you input into the orders table did not exist in the employee table at that time.

[finatrick]

Hi Paul thanks for responding. I figured it out. Since both relationships contain referential integrity, I have to fill out both fields. Thank you guys both.

[pbaldy]

No problem and welcome to the site!