I am having a problem with Enforcing Referential Integrity.    I have watched the video Expert 8 Lesson 5 Several times and can not seem to find my problem.   I have set my relationships per the video for the CustomerT, OrderT and OrderDetailT.   However, when I hope my OrderDetailForm it still allows me to add a record even though it does not give a OrderID.  I am running Access 2010.   I looked at the forum and someone else had the same problem but there is no solution posted.  I know once the Order form is created and I add the OrderDetailF as a subform it will not much matter. However, based on video I should be getting an error message at this point.