Hi, How i can bind more than one column value from one list to the other list. e.g list "Emp" is having columns like empid,empname. Now create a list "dept" with look up column to "emp" in such a way that it should display both column values "empid" and "empname" in dept list. Thanks

can't you create one calculated column in your source list which combines both values in same list and then use lookup column in target list to show that fields. Regards, Vikas Patel.

hi, if you look at my requirement clearly,i have to pull employee id and name from the other list,i think this idea won't works.

In addition to Vikas reply, for combing both the field use following formula = CONCATENATE([empid]," - ",[empname])or= [empid]&" - "&[empname] Ashish Kanoongo, MCP, MCSD, MCTS

Right,but my idea is to bind the 2 columns from "emp" to bind 2 different columns in "dept". Emp Columns Id Name dept Columns Deptid Deptname Empid -it should be from Emp List Empname-it should be from Emp List I think it makes more sense now. Thanks

HI, let me know where you are binding the two Lists. Means whether you have the lists in the data and you wants to display in this way or you wants to create list with such look ups?Thanks Shrivallabh Kulkarni

Hi Shrivallabh, I have two lists and their structure is shown above.First list Emp with 2 columns and 2 list Dept with 4 columns. Now when i try to add a new item in the secocnd list "dept", it looks like this deptid _________123________ deptName ______Sales_____________ Empid ____________________Look up to emp List Empname ____________________must be filled with the above selected employee name. i am going to key in deptid,deptname,the remaining 2 column values should come from other list "emp".for this we can make the 2 columns a lookup,but my idea is i would like to make empid as look up column. ones the user selects empid column it should grab empname and bind it to dept lists empname column. I think you understood my requirement? Thanks

Hi, You may be aware of that it could not be achieved without programming. For your scenario, you can have a look at the following third part solutions: http://www.sharepointboost.com/cascaded-lookup.html http://www.sharepointboost.com/lookupboost.html Hope this helps Thanks! Stanfford

Hi, Now solution is not direct as Hi, Now solution is not direct as Stanfford stated but there are following workaround 1. Write the Event handler which will save EmpName in regards to empID .EmpName will be retrieved by caml query on the Employee list., 2. Create your own custumize WebPart which will be act as input form to save the Records. 3. You can use DataViewer web part which will take input from user and you can controls fields over there. Hope this will help you. Thanks Shrivallabh Kulkarni