05 Order Detail Subform - Microsoft Access Expert 8


	Back to Access Expert 8 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

05 Order Detail Subform

Stamatios Papoutsis

3 years ago

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 Papoutsis OP @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

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 8.

Next Unseen

New Feature: Comment Live View