i am still lost i think
The query that returns the id is as follows
Select
app_admins.app_admin_Last_name,
app_admins.app_admin_First_name,
app_admins.app_admin_email,
service.service_id,
service.service_poc,
service.service_name,
service.app_admin_id
From
app_admins Inner Join
service On app_admins.app_admin_id = service.app_admin_id
the query populates the datagrid, when i click a record, i populate the edit
form where the combo box is, the query for the combo box is
SELECT *
FROM app_admins
ORDER BY app_admins.app_admin_First_name asc
here is edit form code,
<mx:Form id="EditForm" visible="false" includeInLayout="false">
<mx:FormItem label="Name">
<mx:TextInput id="edit_name"/>
</mx:FormItem>
<mx:FormItem label="Point of Contact">
<mx:TextInput id="edit_poc"/>
<mx:TextInput id="edit_ID" visible="false"
includeInLayout="false"/>
</mx:FormItem>
<mx:FormItem label="Application Administrator">
<mx:ComboBox id="app_admin_id_combo"
dataProvider="{AppAdminArray}" labelFunction="AppAdminLabel"/>
</mx:FormItem>
<mx:FormItem>
<mx:Button label="Submit" click="processEdit()"/>
</mx:FormItem>
</mx:Form>
so i am trying to have the combobox display the name where
datagrid.selecteditem.app_admin_id = combobox.itemidex
does this make sense ??
rubeel
On Mon, Apr 28, 2008 at 11:21 AM, Tracy Spratt <[EMAIL PROTECTED]>
wrote:
> For Loop over the items in the dataProvider until you match values.
> Break, then set selected index to the loop index.
>
> Tracy
>
>
> ------------------------------
>
> *From:* [email protected] [mailto:[EMAIL PROTECTED] *On
> Behalf Of *Rubeel
> *Sent:* Monday, April 28, 2008 10:05 AM
> *To:* [email protected]
> *Subject:* [flexcoders] trying to select a value in combo box based on a
> query
>
>
>
> I am running a query and returning some records which contains an ID
> (table 2) value from Table 1.
> i am running another query on the same page to select the values from
> the Table 2 and putting all of it in a combobox.
>
> I want to change the combobox selected index value based on the id
> values i get from the table 1.
>
> is there a way of doing this.
>
> any help will be great.
>
>
>
--
Rubeel Muhammad Iqbal
