3 forms - deleting record in one deletes it in all 3

[matey56]

I have a form "frm_Submission_Planning" that pulls a few fields/data from 2 other forms via a select query. I made those fields locked/read-only on the form. However, when a user deletes a record in frm_Submission_Planning it is deleting the corresponding records in the other 2 forms. Obviously I don't want that. What am I doing wrong? Or more appropriately, what can I do to stop it?

[Welshgasman]

You do not pull data from forms, but tables, perhaps via queries.
Presumably they are child records of the parent record you are deleting? Children records cannot exist without a parent.

[matey56]

You do not pull data from forms, but tables, perhaps via queries.
Presumably they are child records of the parent record you are deleting? Children records cannot exist without a parent.

Correct, I am pulling the data from tables via query. I don't know the children/parent relationship. Each form has a table it's built from. The key field is product name. When I delete a product record from frm_Submission_Planning it deletes it from the two tables the other forms are built from.

[Welshgasman]

So upload your DB, or at least show a picture of your relationships.

[matey56]

I can't upload the DB. The relationship is one query that connects 3 tables that are linked with Product Name. I tried making the "other" two tables "snapshot" or read-only and that didn't work either. Is there a change I can make in the query?

[Welshgasman]

You have not even shown the query code?
Nor the Relationships window?

However when you create the query, are the relationships automatically applied?

That infers, they are set up in the Relationships screen and permanent?