I have 2 web components/forms that have a parent - child relationship.
Parent component is based off of GAGE1 table and has grid and detail. When an action button on the parent is clicked, the child component (GAGEREC table) is loaded. In the onClick Event of the Action button, I have the "Link" set as follows (so the fields are auto populated with the values from the parent):
Target: from SOURCE as:
gagerec.GAGE_ID from GAGE_ID
gage1.GAGE_NUMBER from GAGE_NUMBER
On the child, GAGE_ID is a Hidden control and GAGE_NUMBER is a Textbox and displayed. However, once I add in the link to GAGE_NUMBER above, I get the following error:
Record cannot be inserted because the linking field(s) are not updateable.
Check to see that the Grid contains the linking fields,
and that the control type for each linking field is set to an
updateable control type (e.g. Textbox, Textarea, Dropdownbox, Radiobutton,
Checkbox or Hidden). Note that the 'Link' control is not updateable.
If I don't link GAGE_NUMBER, I can insert just fine but I need the GAGE_NUMBER displayed to the user and without the link, I don't know how to display the value.
Also I am able to update records without any issue.
The child component is based on this SQL Select Statement:
SELECT gagerec.GAGE_ID, gage1.GAGE_NUMBER, gagerec.CAL_ENTRY_ID, gagerec.CALIBRATION_DATE, gagerec.NOMINAL, gagerec.LOWER_TOLERANCE, gagerec.UPPER_TOLERANCE, gagerec.STANDARD_ID, gagerec.REFERENCE_GAGE, gagerec.ACTUA_IIN, gagerec.ACTUA_OUT, gagerec.CALIBRATION_STATUS, gagerec.NEXT_DUE_DATE, gagerec.PASSSED, gagerec.TEMPERATURE, gagerec.HUMIDITY, gagerec.PRESSURE, gagerec.OTHER
FROM gagerec gagerec
INNER JOIN gage1 gage1
ON gagerec.GAGE_ID = gage1.GAGE_ID
I tried adjusting the UPDATEABLE property of GAGE_NUMBER on the child (both checked and unchecked) and either way I get the error. How can I get the GAGE_NUMBER to be display only on the child and not cause the link error?
Parent component is based off of GAGE1 table and has grid and detail. When an action button on the parent is clicked, the child component (GAGEREC table) is loaded. In the onClick Event of the Action button, I have the "Link" set as follows (so the fields are auto populated with the values from the parent):
Target: from SOURCE as:
gagerec.GAGE_ID from GAGE_ID
gage1.GAGE_NUMBER from GAGE_NUMBER
On the child, GAGE_ID is a Hidden control and GAGE_NUMBER is a Textbox and displayed. However, once I add in the link to GAGE_NUMBER above, I get the following error:
Record cannot be inserted because the linking field(s) are not updateable.
Check to see that the Grid contains the linking fields,
and that the control type for each linking field is set to an
updateable control type (e.g. Textbox, Textarea, Dropdownbox, Radiobutton,
Checkbox or Hidden). Note that the 'Link' control is not updateable.
If I don't link GAGE_NUMBER, I can insert just fine but I need the GAGE_NUMBER displayed to the user and without the link, I don't know how to display the value.
Also I am able to update records without any issue.
The child component is based on this SQL Select Statement:
SELECT gagerec.GAGE_ID, gage1.GAGE_NUMBER, gagerec.CAL_ENTRY_ID, gagerec.CALIBRATION_DATE, gagerec.NOMINAL, gagerec.LOWER_TOLERANCE, gagerec.UPPER_TOLERANCE, gagerec.STANDARD_ID, gagerec.REFERENCE_GAGE, gagerec.ACTUA_IIN, gagerec.ACTUA_OUT, gagerec.CALIBRATION_STATUS, gagerec.NEXT_DUE_DATE, gagerec.PASSSED, gagerec.TEMPERATURE, gagerec.HUMIDITY, gagerec.PRESSURE, gagerec.OTHER
FROM gagerec gagerec
INNER JOIN gage1 gage1
ON gagerec.GAGE_ID = gage1.GAGE_ID
I tried adjusting the UPDATEABLE property of GAGE_NUMBER on the child (both checked and unchecked) and either way I get the error. How can I get the GAGE_NUMBER to be display only on the child and not cause the link error?
Comment