I have a form which contains two cascading lookups, the first is Department, the second would be the Manager and their Backup. I can eliminate one of the lookups be cause I know the value of the department which is coming from a different list and I'm already collection this in the workflow variables. I want to eliminate the need to have to select the department to get the managers listed for that department. What I need know is how to use this Runtime "Lookup" Function to lookup an item from "LIST A" and insert the column value into this runtime formula. The syntax is as followed lookup(list title, column to filter on, value to filter on, output column) but I cant seem to get the Department name to display on my form. Can anyone offer some help? I need the value in so I can filter on the managers name so if the department value is "IS" the it will list the manager and there backup in the pull down, If the department is "Accounting" then it will display only those for accounting.
Anyone have a solution out there?
Thank you in advance