To summarize I have a form that's pulling a list of projects from SharePoint, the thing is this list has a department column. Basically I want to have a different form for each department so when someone from department X opens their form, the dropdown list of projects only shows projects whose department column corresponds to their specific department. Is this possible or do I need to make a unique project list for each department and make the dropdown point to each respective list for each one of them?
Thanks in advance for your help!