Attached is a smaller version of my project database. This is my first database and I'm sure there is hundred things wrong with it but, please bare with me and my 1 year experience with Access.
When you open the db, and want to enter a new record (or new project), I push the 'New (BLANK) Record' button. I then enter data in the General page, then Design Page, etc.
'Brad's Project Number' is field that links the main form to the subform, so you need to enter a number in this field in the General page.
The problem I have is when you tab to the Design page and enter data and then tab to the Construcion tab. I get the 'Index or primary key cannot contain a Null value'.
If I delete the primary key in the tblDesign, then I get the
'Cannot add record(s); join key of table 'tblDesign' not in recordset' error.
Any ideas on how to fix this?
It's probably how I've set this up with subforms but, don't know.
Any help would be most appreciated.
When you open the db, and want to enter a new record (or new project), I push the 'New (BLANK) Record' button. I then enter data in the General page, then Design Page, etc.
'Brad's Project Number' is field that links the main form to the subform, so you need to enter a number in this field in the General page.
The problem I have is when you tab to the Design page and enter data and then tab to the Construcion tab. I get the 'Index or primary key cannot contain a Null value'.
If I delete the primary key in the tblDesign, then I get the
'Cannot add record(s); join key of table 'tblDesign' not in recordset' error.
Any ideas on how to fix this?
It's probably how I've set this up with subforms but, don't know.
Any help would be most appreciated.
