Adding/Deleting COJO from CO causes same record to appear twice in navigator

[pashiav]

Describe the bug
When there are 2 or more items in the navigator then refreshing on a CO's record, adding or deleting COJO from that CO causes the same record to appear twice in the navigator. Behavior has been seen in Loans too.

@emenslin found that a record set can be made with the duplicate record.

• When querying CO, there is only one unique record for this CO:

• but when querying the record set, there are two of the same record:

To Reproduce

1. Create a new COG -> Save
2. Create a new CO (Data Entry -> Collection Object) -> Add the new COG as CO's COJO
3. Save & Refresh, note that there is now only one item after refreshing and the navigator is gone
4. Delete COJO from CO -> Save
5. See that another record has appeared in the navigator. Use the arrows to navigate to the other record and see that it is just the same record.
6. Create a record set (https://ojsmnh20241003wb-issue-6139.test.specifysystems.org/specify/view/collectionobject/228365/?recordsetid=598)

Expected behavior
Should save record without adding another item in the navigator.
Should not be able to create a record set with the same record.

Recording

Screen.Recording.2025-01-23.at.9.50.50.AM.1.mov

---

• OS: macOS Sonoma 14.6.1
• Browser: Chrome
• Specify 7 Version: issue-6139, when merged: production
• Database Name: ojsmnh20241003wb
• Collection name: Fossil Invertebrates
• User Name: spadmin
• URL: https://ojsmnh20241003wb-issue-6139.test.specifysystems.org/specify/view/collectionobject/228365/?recordsetid=598

Additional context
Found issue from #6147.
Original comment: #6147 (review)

[CarolineDenis]

@specify/ux-testing Can this be verified?

[emenslin]

Can recreate it consistently in COs following Pashia's instructions

03-18_12.40.mp4