Need help in sharpoint 2010 look up field.

Hi all,

I have a list in sharpoint 2010 say for EmployeeList:Fields are Empid and Managerid.

The sturcture of the list is like below:

empidmanagerid

emp001manager001

emp002manager002

emp003manager001

emp004manager002

emp005manager001

using the above list creating another list say for EmployeeLookup list, in this list empid and managerid is

lookup field. after creating these two lookup field both the fields are becoming dropdown list filling with

values..empidlookup dropdown with all the employeeid from EmployeeList(reference list) and manageridlookup drop

down with all the managerid from EmployeeList(reference list).

query1: For the secod lookup i.e manageridlookup in second list i want unique values so in this case manageridlookup

should fill up with values only manager001,manager002 but its filling with all the values from EmployeeList(reference list).

When i am selecting enforce uniqueness for the manageridlookup property. i can not add second record for the

same manager..many employee can report to same manager right!

query2: While selecting empid from second list i.e lookup list automatically managerid should be poped up mangerid lookup field.

How can i achive the above functionality any help pls....