I have two lists. First one is a Projects List and Second List has a lookup column to the First list. I want the lookup column on Second list to show only the Projects filtered by the column "Created By".
In example: If John Doe Created a Project in the first list, then, John Doe will go to second list to create a record but The projects lookup column should only show projects created by John Doe and not all other project created by someone else. I am using Sharepoint 2016.
Your support is really appreciated.