Integrate form fields from another table with a many-to-one relationship

Get Help
3

Hi Marion,

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 which fieldNumber 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.

<row>
	<cell type="label" labelfor="FieldNumber"/>
	<cell type="field" id="FieldNumber" name="fieldNumber" uitype="text" colspan="3"/>      
	<cell type="label" labelfor="Collecting Field Number"/>
	<cell type="field" id="Collecting Field Number" name="collectingEvent.stationFieldNumber" uitype="text" colspan="3"/>
</row>
<row>
	<cell type="subview" id="CollectingEvent" viewname="CollectingEvent" name="collectingEvent" colspan="24" rows="5"/>
</row>

Here is what a preview of an editable field.

image

Thanks!