I have created the relationships between CustomerT, OrderT and OrderDetailT but still I am able to enter new records to OrderDetailF without receiving any restriction message that there are not any Related Records in the OrderT for these New records. I have checked the data many times and I can't find the reason for that. Any ideas?
Best regards,
Stamatis Papoutsis Greece
Stamatios PapoutsisOP
@Reply 3 years ago
I finally found what was the reason of my above stated problem!!! After watching 06. Order Form video, I remembered that inside OrderDetailT table the default value for OrderID field, whose type is number, was set by me to NULL instead of it's original ZERO value setting!!! As Richard mentioned in 06. Order Form video, the referential integrity does not responds well with NULL fields so that triggered my memory and realized that I did the same thing to my OrderT table for CustomerID field (set it to Null) and to my OrderDetailT table for OrderID field.
I'm very glad that I solved my problem because it took me more than three hour of testing and changing things in my database objects...
Best regards,
Stamatis Papoutsis
Greece
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 8.
