I have 2 List... One with Month (Text) & Release Date (Date & Time) And on Other List I am using Month (lookup), which looks up month from 1st List and this List also has Release date (Date & Time) which I want to populate automatically based on Month (lookup) Say 1 item in 1st List: Month Release Date May 05/16/2011 Then if someone selects Month May from Lookup in other field then the Release Date should be populated to 05/16/2011.... I tried using SharePoint Designer Workflow but that doesn't recognize Month (lookup) field on 2nd List... Also, even Calculated columns doesn't show Lookup column Is there any way I can achieve my goal of lookup value for Month from other list & auto-populating value of Release Date.. Any thoughts on this would be greatly appreciated...

In your first list, is there only one month per release date? In other words, do you only have one "May", one "June", one "July", etc? In the second list, is your lookup a single or multiple value lookup field?Planet Technologies || SharePoint Task Force

Yes only 1 Month but it doesn't have full 12 months, and the list keep changes to next 7 months... Single value Look up

You should be able to do a "Set field" action in your workflow on your second list to set the Release Date value in the second list. Your action should set field List2:Release Date to List1:Release Date where List2:Month is equal to List1: MonthPlanet Technologies || SharePoint Task Force

Hi Ashish, Following on the threads here, I notice there is a data redundancy for both fields (Month & Release Date) in both lists. Surely, you are better of recording these dates once and link both lists via the use of lookup columns. Finally, have a page with two dataview webparts that show related records. hth,-- techChirag