Hullo, I'm an Access novice programming a db for data entry and would be very grateful for any help - I'm stuck on this one! When I attempt to save a new record on a form, I'm getting an error that reads "The record cannot be deleted or changed because table "X" includes related records." Table "x" is a subform, so of course it is related, but I don't understand why the save command doesn't just save the data in the form and subform.
What seemed to spark the problem (the db was functioning perfectly) was that I changed the primary key for the parent table/form from an autonumber to a manual number (integer). I'm using the same primary key to link the subform to the parent form.
Any tips?