I have a form with a subform in it. When I try to add a new record it gives me an error that I cannot add record the joins key of table <name> not in result set. When I try to delete the record it does not delete the record from the subform. I checked the 1 to many relationship and the boxes for for the cascading delete and update are checked. If anyone can help me fix this it would be greatly appreciated.