I use the “Treatment event” table to enter ‘historical’ information related to an object. I have renamed this table “Historical events”. For simplicity’s reasons, I need to attach this table to the Collection Object table and not to the Accession table.
In my form, when I attach my table to the Accession table, I have the magnifying glass logo that allows me to search for pre-existing records.
It would be very useful to be able to search for pre-existing records so that I don’t have to fill out the form again, as the information will often be the same. Is it possible to fill in the fields in my ‘Historical events’ table automatically without having to fill everything in again?
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!
I understood that the difference between the two behaviors of the Treatment Event table had to do with Dependent vs. Independent Relationships. Nevertheless, it would be great to be able to choose this dependency/independency for certain tables. Which is already the case for some tables like Collecting event if I’m not mistaken?
And thanks for opening the ticket to be searchable on this table from Collection Object.
