Dynamic Population of Sharepoint fields
<p>Can someone please help me with a query on Sharepoint?</p>

<p>Suppose, I have a list called employee database and the list has two columns Name and employee ID.</p>

<pre><code>Employee ID   Name
1             John
2             Mary
3             Peter
4             Mark
</code></pre>

<p>Now, I create a new list called, employee registration tracker and have following field in this list;
Employee ID
Name
DOB</p>

<p>Is there any way by which, while entering a new item in this new list, I just enter employee id and using some javascript, it fetches ‘name’ corresponding to that ID from employee database list and automatically populates the field ‘Name’ in this list. So this way we do not have to again enter name.</p>

<p>We have approx 500 team members in different teams and we need to keep track of them.
I tried various ways like cascading dropdowns etc, but such a big list it does not allows. Also like I told you earlier, I need to make all this in my enterprise firewall and other restrictions where they do not allow sharepoint integration with MS access , Sharepoint developer etc and the only way I have is easy javascript in CAML.</p>
