I have an "Employee" list which contains username and employee no. and there is another list which contains a column that lookups employee no. in Employee list.
The issue is that I want to show only that employee no. in lookup field where username is equal to current username.
How can I do it using Infopath?
Any help would be highly appreciated.