May 08, 2009, 4:45 PM
populate grid row/field from a parent table on a ComboBox
Hello,
I'm trying to populate a value on a grid row/field that comes from a parent table on a ComboBox.
For example, the value in the grid row/field is a SYS_GUID that translates to a row on a reference table. So I have a ComboBox that uses a <ext:Store> that populates the values from that parent table.
example
Could you please tell me what is missing from this syntax to display the actual name instead of the value and populate the ComboBox at the same time?
Thank you,
I'm trying to populate a value on a grid row/field that comes from a parent table on a ComboBox.
For example, the value in the grid row/field is a SYS_GUID that translates to a row on a reference table. So I have a ComboBox that uses a <ext:Store> that populates the values from that parent table.
example
<%-- Store for the ComboBox --%>
<ext:Store ID="storeDivision" runat="server" DataSourceID="SqlDataSourceDivision" AutoLoad="true">
<Reader>
<ext:JsonReader ReaderID="DIV_ID">
<Fields>
<ext:RecordField Name="DIV_ID" />
<ext:RecordField Name="DIV_NM" />
</Fields>
</ext:JsonReader>
</Reader>
<SortInfo Field="DIV_NM" Direction="ASC" />
</ext:Store>
...
<ext:Column ColumnID="REGNL_DIV_DIV_ID" Header="Regional Division" DataIndex="REGNL_DIV_DIV_ID" Width="200" Sortable="true" AutoDataBind="true">
<Editor>
<ext:ComboBox DataIndex="DIV_ID" ID="Division" runat="server" StoreID="storeDivision"
DisplayField="DIV_NM" ValueField="DIV_ID" Editable="false" TriggerAction="All"/>
</Editor>
</ext:Column>
But this still displays a guid value instead of the Division name. Could you please tell me what is missing from this syntax to display the actual name instead of the value and populate the ComboBox at the same time?
Thank you,