I have two lists called "Project Managers" and "Projects".
In ProjectManagers list I have added some names in Title column. In Projects list I have created a column(Projectmanagernames) which is Lookup column related to Project managers list.
My requirement is when I select ProjectManagersname in the first dropdown, in the second dropdown projects has to come which are related to selected project manager name.
I have tried SPservices also but I'm unable to achieve this. Can anyone please help me?