But can I integrate the “Filed Number” field (and make it editable) from the Collection object table into the Collecting event form like this (many-to-one)?
For the purposes of our collections, we need both field number fields, the one in the Collection Object table and the one in the Collecting Event table. At the moment the ‘Object fied number’ field is ‘outside’ the Collecting event information part in the form, which confuses most users. Is there a way of making the form more intuitive for users who don’t understand relational databases?
It would be great if I could put the two fields collectionObject.fieldNumber and collectingEvent.stationFieldNumber next to each other in the ‘Collecting infromation’ section.
Thank you for your question. After reviewing, we can confirm that you cannot edit the collectionObject.fieldNumber from within the Collecting Event form due to the database relationship between Collection Object (CO) → Collecting Event (CE).
Essentially, since there can be more than one CO linked to the CE in the database (see embedded vs. shared), Specify cannot determine whichfieldNumber value to show, even if there is only one linked CO.
However, there is still a way to integrate the fields side-by-side on the data entry form.
You can add collectingEvent.stationFieldNumber to the Collection Object view definition. This will allow both field numbers to appear in the same section of the Collection Object form, with both fully editable.