cannot delete records added through the subform (1 Viewer)

[yugesh437]

I have 2 sub-forms attached to a main form.
Each of these forms are based on different tables.
Whenever I input the record, it goes into respective tables.
However when I try to delete the record, it only deletes the record from the main form.
I tried cascade delete. However, since referential integrity has to be established, I cannot add the record to my subform because there has to be a corresponding record in the parent table for me to add the record in the subform.
Could I receive some assistance?

 

[Beetle]

Is there some reason why you don't want to enforce RI?

 

[Pat Hartman]

For cascade delete to work, you must enforce RI.

If your subforms are giving you errors about parentage, try fixing the master/child links. That is what tells Access the fields that the two tables are related on. Once those are set correctly, whenever you add a row to the subform, Access knows where to get the foreign key value.