Cannot add record to a table because related record is not recognized

[Mythblstr]

Hi everyone,
I am using Access 2007 and I have a database with 2 tables. The original table has a primary key field designated. I have a relationship between that table and a second table and that relationship has "enforce referential integrity" checked.

In the secondary table the field that the relationship is bound to is not a primary key but has the same field properties.

I created a new record in the original table and created the primary key of "T-124". When I attempted to add the same data to the field in the second table, I recieved the following error message: "You cannot add or change a record because a related record is required" in the other table.

I did create the record in the other table

Can anybody help????

 

[boblarson]

Did you accidentally link together two autonumber fields? You should have one autonumber linked with the second table's Long Integer field which stores the auto number from the first table.

 

[Mythblstr]

I'm not sure what an autonumber is but Access did not create these numbers. The numbers are unique identifications that are associated with each record. I used these IDs because they are the only field in any record that will be absolutely unique.

This is a variation of the qustion I asked about why a record created in a table wouldn't show up in a form last month....

 

[boblarson]

Can you post a stripped down version of the database here (including removing any sensitive data)?

 

[Mythblstr]

Can I upload it direcly to you Bob?