Employee Master Data
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
Yatsea Li replied
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.