Why Aren't Relationships Enforced

I have a table with a many-to-one connection

Each record in Table A can connect to multiple records in Table B, but Table B can only have one connection to Table A.

If something is edited in Table B that changes its relationship to Table A and it connects to a different record I would expect the first relationship in Table A to be removed, but it is not.

I have been banging my head against integromat trying to get this automation to work for something that should just happen in knack.

Why even have this relationship if it is not enforced?

Hello! Are you sure you are not “duplicating” the relationship? I mean, if you have already established the relationship in record A, you don’t need to create the relationship again in record B. I don’t know if I’m explaining myself.