Dear All, I want to select some item form other list like Master Detail form how to enable this things in my required list. Rgds TahirTeeJay

Hi, if you mean Performing joins between SharePoint lists check this http://blah.winsmarts.com/2007-10-Performing_joins_between_SharePoint_lists.aspx Best Regards, Ammar MCT http://ahmed-ammar.blogspot.com Posting is provided "AS IS" with no warranties, and confers no rights.

Hi TeeJay, Not quite understand your question. Could you explain your requirement in detail so that we can provide pointed solution to the issue? Lu Zou

Dear Lu Zou, I have one list1 there is 4 fields like field1, field2, field3 & field4, field1 is the primary Key I have another list2 with 4 fields like field1, field2, field3 & field4, field1 is the primary Key and the Field2 is Foreign Key (List1.field1 = List2.field2) I want to insert data fromm list1.field1, field2, field3 in List2.field2, field3 & field4. When i select list1.field1 in list2.field2 the list1.field2 & list2.field3 data populate automaticly in List2.field3 & list2.field4. Because when i make a lockup field the field provided the list for the specific column. How i can done this please help Regards TahirTeeJay

TeeJayMT, try the list lookup option if u want to connect certain field or columns with each other to populate other columns in order to link lists in different sites across your collection try the filtered lookup list at www.codeplex.com