Im working on my project for school where we are developing an application that will work with the Northwind example database that was provided with Access. 2 new tables were added to the db which are PurchaseOrder and PODetail. They have a 1:1 relationship.
My question is that because of the referential integrity, I cannot INSERT any rows into either table because when it looks for a corresponding row in the other table its not there yet so it gives me a NullPointerException.
I have two subs that are handling the insert commands: InsertPODetail(.....) and InsertPurchaseOrder(.....)
Is there a way that I can add the rows with R.I. turned on without getting the exception? Or should I just say screw it and turn it off
Heck I had such a bad teacher in my Database class that I didn't learn all this junk so now when I actually use it in another class I cant figure it out....how appropriate!
Linear Mode
