Hi @Marion,
Thank you for your question!
The ‘Treatment Event’ table has different relationships between the two tables. The difference here lies in the fact that one is dependent (Collection Object) and one is independent (Accession). See Dependent vs. Independent Relationships
Accession
Treatment Event on the Accession table has a one-to-many relationship, and it is independent.
An independent relationship means that the related record can exist on its own, regardless of whether it is referenced by another record. The “child” is not owned by or tied to the “parent” in a way that its existence depends on it. In editing scenarios, clearing a reference to an independent record does not delete that record; it only removes the link.
Collection Object
Treatment Event the Collection Object table has a one-to-many relationship, but it is dependent.
A dependent relationship means that the existence of a record in the “child” table depends on the existence of a record in the “parent” table. If the parent is deleted, the dependent (child) should also be deleted. In editing scenarios, if all fields of a dependent record are cleared, the record can be safely deleted, since it cannot exist without its parent.
This means you cannot look up existing Treatment Event records from the Collection Object form, but as you described it is possible for the Accession form.
Is it possible to fill in the fields in my ‘Historical events’ table automatically without having to fill everything in again?
At the moment, you will need to create a new Treatment Event for each Collection Object, but this is something I will run by our team to determine if we can alter this behavior for you and others in the future. Thank you again!