Form help - field update fail
Windows Vista 
Access 2007
I'm a novice at building databases, and only remember bits and pieces from a project a few years ago. I have done a lot of reading to tried and solve this on my own, but since I'm still running into issues, I'm reaching out for help. I've described my set up and issues below, but also attached screen shots for reference.
I have four tables: tblOrder_Details, tblOrders, tblProduct_Descriptions, tblSupervisors. I have a one-to-many relationship with [tblSupervisors].[Supervisor ID] to [tblOrders].[Supervisor ID], [tblOrder_Details].[Supervisor ID] to [tblOrders].[Supervisor ID], and [tblProduct_Descriptions].[Item Number] to [tblOrders].[Item Number].
I used the form wizard (hey, remember I'm new!) and ended up with a form in form called Order Entry. It auto pulls the supervisors on the main form and allows me to enter in orders for each supervisor; to switch to a different supervisor you'd click the next record. On my sub form are four fields: Order date (default value set to =date()), item description (combo box pulling from [tblProduct_Descriptions].[Item Description], quantity (default value 0), and total cost (calculated field of =[Quantity]*[tblProduct_Descriptions]![Cost]).
When I go to form view of my entry form, and try to enter in a new order for a supervisor, it gives me an error saying "field cannot be updated." Once I ok that and tab through, it says "index or primary key cannot contain a null value."
Again, I'm a novice, so play nice, but I'm about to pull out my hair with this. My ultimate goal is to be able to track orders, have each order adjust the inventory, and to be able to pull reports showing order requests per supervisors (which in turn will indicate departmental and divisional spending). I hope I've given enough information for help - or at least to a good resource to read more.
Thanks!
Reply With Quote
