I have a list which contains a column for Name and a column for Department
I'm building a secondary list which will contain two look up columns. These looks ups will display the Name column from the first list however what I'm hoping to achieve is having the look up only showing names related to a specific department.
Look up column 1= Mr.Smith from Finance (Or anyone within Finance)
Look up column 2= Mr.Bloggs from Human Resources (Or anyone within Human Resources)
I have filters for each department in the first list but can't seem to find away to filter the look up. I had a quick google search but only found results for more complex issues and this seems simple enough just think I'm missing something.
If someone could point me in the right direction or offer any advice it'll be greatly appreciated.