Can't add new record message

[SamMaynard]

I have a form with fields linked to two tables that are related one-to-one(for confidential information storage). When I enter data on the form and then try to add a new record a message comes up that says, "You cannot add or delete record because a related record is required in another table." Then I press ok and exit out of the form and look at the actual table (not by way of the form) and the record is there! Then I go back to the form and It's not there! Madning!

Have any Ideas? Need more info? Thanks so much. Sam

 

[Joe4]

Without actually seeing the database, the first thing I would say to check is the Relationships linking the two tables.

I don't know if these situations might cause errors, but:
1. are you linking on fields which are not primary fields?
2. are there other tables in one-to-one relationships that also need to be updated?
This message was edited by jmiskey on 2003-01-28 16:36

 

[SamMaynard]

The two related tables are student records information. The GeneralInfo table has a primary key called StudentID. The other table is ConfInfo and has the same primary key StudentID.

These two primary key are linked One to one with referential integrity enforced and delete related records marked. I don't have cascade update related field marked because access gives me an error message of Invalid Field definition if I do.

In the datasheet view this works perfectly. The sub datasheets come up and work great also. It's just when I'm using the form. It may also be good to know that on the form I don't have the Primary Key field avalilable because it's an auto number.

Thanks, Sam

 

[Joe4]

I'm not sure.

Are both the Primary Keys that are linked Autonumbers?

Try putting the field on the form. You can hide it if you want by changing the Visible property to "False".