Unable to add record to a table

[lisarmj]

I have a database that has been working properly for months...however, suddenly I am unable to add records to a number of my tables.

Each of 10 tables are related to a main table with a 1 to 1 relationship - the relationships have not changed.

Can anyone think of any table setting which I may have inadvertantly changed that would prevent additional records from being added?

I am still able to add to the main table and I have added several new tables also with a 1 to 1 relationship with the main table that are all working fine.

Thanks!

 

[EdFred]

What is the error message when you attempt to add data?

 

[lisarmj]

I actually figured out my problem...it was a silly mistake. The tables were all joined to the "main table" with a one-to-one relationship specifying unique, enforecd, cascade updates and deletes (as they should be), however, I was testing a change to the main table and copied it renaming the original table and working with the copy which had the same name as the original...I wasn't thinking that the relationships all stayed with the original table and not the copy with the name of the original table...I re-established the relationships to my copy table and all is well again...this is what happens when you work on the fly late at night!!

 

[EdFred]

Heck, I've done stuff like that at 3 in the afternoon.