Employee Master Data

[Former Member]

hi!

The problems as follow:

1. How I can create a View Child button in the Personal tab ?

2. After clicking View Child button, how the system only can display the 1-1 employee information ( Employee No 1à only show his/her child not show all Employeeu2019s child in the company)

3. Which method or SQL command to use for ADD NEW & UPDATE button in the List Childu2019s Employeesu2019 Form?

[[IMG]http://img402.imageshack.us/img402/8409/huynhhf3.png[/IMG] | http://imageshack.us]

[[IMG]http://img402.imageshack.us/img402/huynhhf3.png/1/w1019.png[/IMG] | http://g.imageshack.us/img402/huynhhf3.png/1/]

Edited by: Huynh Nguyen on Oct 2, 2008 11:36 AM

[YatseaLi · Accepted solution]

Hello,

1.Set the property FromPane and ToPane Item as 4 for the View Children Button when adding it in the form load

2.Draw the children form with grid binding with the DataTable. Filter the grid by condition of parent

Set oDataTable = oForm.DataSources.DataTables.Item(m_DataTableUid)
'replace the U_**** and 88888 accordingly
queryStr = "Select U_***, U_**** from [@MY_UDT] WHERE U_parent='88888' "
oDataTable.ExecuteQuery queryStr

3.It is up to you.

Insert or Update SQL

Hope it helps. Thanks.

Kind Regards

-Yatsea