I have converted (from another database) and am working in a relational (8 tables) access 97 database. I have a main form (based on queries involving the parent and several child tables) where data is entered that corresponds to several tables. (My relationships are set up with enforced referential integrity and cascade update and delete). Existing records in the parent and child tables are fine. When I enter new records in the form however there is a problem. Putting data in fields that correspond to the child tables produces an error saying the primary key can’t contain a null value (b/c it doesn’t automatically add a corresponding [primary key] record to the tables). I put in a macro so that when users click in the field it sets thevalue of the index field of the child to that of the parent table and it works fine, but I feel like it should do that automatically since it is just a basic relational set up.
Would love any suggestions!