I came across an issue recently where a linked record column in table ‘A’ without the option to allow multiple linked records, still contained some records with multiple links to records in table ‘B’.

Upon researching the matter it turns out that when you duplicate a record in table ‘B’ it duplicates the entire record including the column tracking the reverse link to records in table ‘A’ and therefore causing the record in table ‘A’ to now contain a second link to the newly created record.

I understand why this is happening, as duplicating the record in its entirety includes the linked records column, however i am not sure this is the correct behavior, certainly if it violates a constraint added in another table