Grid Combo box enter ax2009

Hi friends
Pls help
I have table empl inside table
Anum int number empl
Name string name empl

form è Gridè field(Combo box)
form è Gridè field(StringEdit)
from Combo box when I dropdown and click number I need to show the name in field(StringEdit)
what I need

1- Write to Function to get the name

2- Where I but this function in which method and where (table- Combo box)

hai bas:

please explain in detail and clearly…

when u say u need the name… but from where ?

Hi Bas,

It is not clear…can you explain it…

Naresh Kolli

in table empl have 2 field (empl_no ,name )

(1,2,3 …) empl_no

(bas , Naresh Kumar Kolli , Shon Davis) name

in the Grid have to Columns

empl_no when i dropdown data

(1,2,3 …) when i click show me data in the name Colum name (bas , Naresh Kumar Kolli , Shon Davis)

i hope It is clear

i hope it clear

ihave table this table EMPL_TABLE have 2 field (EMPL_NO, EMPL_NAME)

icreate form this form have Grid and this Grid have 2 columns first colum combo box have EMPL_NO from EMPL_TABLE

now what ineed when dropdown and click number I need to show the EMPL_NAME from EMPL_TABLE in sec2 colum after chose the number from combo box show the name sec2 colum NAME automaitic no need to write in the name field

[H][H][H]

HI bas,

write the code in Modified method.

Tb.name = TableName::find(DSName.EmpNO).Name;

HI Bas,

FOrm->DS->Fields->emplid->modified() Method

{

EmpleTable empl;

select firstOnly empl where empl.emplNO == EmplTable.EmplNo;

EmplTable.name = empl.name;

}

thanks it works