I have 2 tables (A & with a one-to-many relationship and the "Delete related records on this table when a record is deleted in the other table" is ON on table B.

So when I delete a record on table A, all related records on table B is deleted. It's working as expected.

Now, I created another instance of A & B in the Relationships window and called them A2 & B2 and there is NO relationship between them. Created 2 layouts that used the A2 & B2 table instances.

Now when I delete a record on A2, the records on B2 ARE ALSO deleted. Is that suppose to happen even though there is NO Relationship between them?

And I also tried putting a one-to-many relationship and this time, Turning the "Delete related records on this table when a record is deleted in the other table" OFF on the B2 table.

And when I delete a record on A2, it does the same thing. It seems like it still using the relationship between A & B instead of A2 & B2.

Is this a bug? I haven't tried any database maintenance yet. I'm going to do it, and I'll see if anything changes.

Is this a bug?

No. It cannot work any other way. The option to delete related records is designed to ensure relational integrity (preventing orphans in your example). Usually, you would use this in your core relationships. If defining another relationship (say, for the purpose of a value list) would cancel out the core setting, the results would be disastrous.

Another way to look at it: you delete records from a table - not just from one specific occurrence of the table.

THANK YOU!!