Get data from another list in the new form
Posted: 01 Sep 2015
Hi,
We have two different lists, one of them is for employee data. It is holding employee information and number of leave of absence days of each employee. The other list is for leave of absence request. An employee creates a leave of absence request from new form. What we need is to show how many leave of absence days left for the employee who is creating the request in the new form. We tried to get current login name and use it with related items to get data from the employee data list but it is not feasible as we just need one column value and show it in a plain text control. We really stuck at this point and any help will be appreciated.
We have two different lists, one of them is for employee data. It is holding employee information and number of leave of absence days of each employee. The other list is for leave of absence request. An employee creates a leave of absence request from new form. What we need is to show how many leave of absence days left for the employee who is creating the request in the new form. We tried to get current login name and use it with related items to get data from the employee data list but it is not feasible as we just need one column value and show it in a plain text control. We really stuck at this point and any help will be appreciated.