I'm having trouble with my @XLookUp programming. Here is my code:
var vSalary as Double
vSalary = @toMoney(@XLookUp(@Fn, Employee Name, "EmployeeManagement!Employee", "Salary"))
Salary0 = @STR(vSalary)
I'm wanting to look up the employee by their name, and find their current salary. It's all on the same application, just different forms.
Employee Name is the element on the current form.
Employee is the element on the form I want to retrieve from (EmployeeManagement).
Salary is the data I want to retrieve.
Both elements are set to type MONEY, which is why I used a var Double.
For whatever reason, the value returned is always $0.00.
Any ideas?