I want to create a list where view can look like Employee_Name, Employee_ID, Start_Date. Now if I click on Employee_Name, it should bring up more details about that employee like designation etc. Is it possible to do this SP?
You can hide Designation etc. from View, and Employee_Name can be Title field renamed, once you click Title by default it will open details of the item in popup which will include Designation.
Simply click Title column in List Settings and change the column name to Employee Name.