I am far from an expert w/Access 2003 but I have managed to create a database. I use forms to add data to tables. The main form is Orders where I enter an OrderID. I use a command button to launch the next form where I add WorkOrders associated with the OrderID. I set up the
WorkOrders form to pull the OrderID from the main form and populate that
field. The workorders table primary key is a field called SID which I fill in
manually (at this stage, later to be autonumber). After filling in all data in the WorkOrders form and hit "enter" or install a "Save" command button Access comes back with "Primary key can not contain a null value", when obviously the PK value is not null.
I'm doing all of this with no knowledge of VB code, just using wizzards and modifying properties. Any basic help is appreciated.