Unanswered: Broke my DB :( can you help? - You cannot add or change
I don't know what happened but when trying to add a record to a subform I get the following error:
You cannot add or change a record because a related record is required in table 'tbl_Client--
I only have tbl_Client. tbl_Client-- was a duplicate table that was deleted.
yes well the message indicates your subform/mainform records have a sync issue.
because there is a main & sub - - then 2 tables are involved. lets say you go to a new record in the main and attempt to put info into the subform but haven't put any info in the main form yet - - so there is no primary key for this brand new record existing.....which is why the subform will balk - - because it is "sub" and it wants to see that primary key before you put any info into it....