SharePoint Lookup fields are not visible while creating new Items and before submitting the items

Ganesh_bccc

Overall topic here is.. Manager wants to have track on labor hours.. Means employee used to move from one project to another so how many hours, a particular employee works for particular customer or project need to track

Please find my attached file which will give you a overall picture of my task.

This is in SharePoint Workflow. I believe this issue can be resolved with JavaScript or HTML. Please help.

There is two custom lists.

1. Master Data site = It has all details about columns relating to employees details. We can say it as our source file. Employee Details include columns for:
   Employee Name,
   Employee Id,
   Dept,
   Supervisor name,
   Customer/project code for which the employee works and
   Program manager name

2. Another custom list is for user = here I have created columns which include lookup also. It means once User will select Employee Name, all other details like Supervisor name, Dept, customer code etc will come from Master Data site will be filled.

Here only problem is when I create new item, the form does not show the lookup columns. Only when I submit, then only it gets filled.

Actually my intention is here.. When User will fill Employee Name, he must be able to see all other fields including lookup fields before submitting it.

The attached excel file will give you more clear picture of the task..

I really appreciate for your support. Once again thank you so much..