I have table with following columns.
a) Department Name
b) Employee Name
I want to show or create LOV with just Employee Name but need to pass Employee_id to the main query from the Lookup values rather then Employee Name.
Its a BI Report and not Analytical.