Simple Relationship Class unexpected (?) deletion of data (foreign key)

KIVANC — Thu, 01 Dec 2022 16:30:45 GMT

I have two feature layers in a geodatabase. Simply assets layer and inspection layer.

I have created a one to many relationship class where the relationship type is simple and message direction is set to none. Assets are in destination table and inspection on origin table. Primary-foreign keys are simply names of the assets

When I delete an inspection record, it deletes respective the asset name in the assets layer which is not I would want. Is this a normal behavior? I assumed a simple relationship type wouldn't have an effect on the destination table. If so, I am confused with what other options such as composite, forward backward message direction actually do. I tried to look for a documentation that explains with examples but I could not find.

Any help is much appreciated.

topic Simple Relationship Class unexpected (?) deletion of data (foreign key) in ArcGIS Pro Questions

Simple Relationship Class unexpected (?) deletion of data (foreign key)