Solved

How to move souce List1 Data to Targer List2 data and how to use choice column value in target list coulmn through lookup column?

Posted on 2011-03-10
6
352 Views
Last Modified: 2012-05-11
Hi,
I am having two list one is source list List1 and target list List2.List1 has some column with choice value and when the user will enter new row/value in List1 then the same value i want to populate in List2.
Exp: Source:  List1-> Manager name(Choice Type),Request Date(TodayDate),UniqueTag# (Autogenerate-Text)

In the target list we have  total 30 column where first 3 column are same as List1 which user entered just now. When User will enter the data in List2 , i want the first 3 col should be autogenerate from List1 because as user has already entered the value previously.
I can see the use of Lookup value in SP2007 but when i select the "Get information from:" i.e. List1 then "In this column:" i am getting only text type col name here ,the choice col is not listed here in "In the column" .
So i can see here only my "UniqueTag#" column because its a text col here.
How to achive this with lookup technique or any other idea.
Pls Note:Our Client is now allowing for any custom coding for SP2007 in .net.

Please Help.
Thanks
0
Comment
Question by:neenavishwakarma
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 12

Expert Comment

by:Hairbrush
ID: 35097674
Have you considered using a workflow created in SharePoint designer to automatically create an item in list2 when you finish creating the item in list1?
0
 

Author Comment

by:neenavishwakarma
ID: 35097818
no i have not done through workflow...how its possible?
0
 
LVL 12

Accepted Solution

by:
Hairbrush earned 500 total points
ID: 35098012
Do you have SharePoint Designer 2007?  If not you'll first need to download and install it.

Then, take a look at http://office.microsoft.com/en-us/sharepoint-designer-help/create-a-workflow-HA010100591.aspx
0
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 

Author Comment

by:neenavishwakarma
ID: 35234041
we did have SharePoint Designer 2007 means my company didnt have that but in couple of month they are in process of deploying Nintex workflow.Is that will help for same.Can i try in this workfolw as your suggest soluction.Pls let me know
0
 
LVL 12

Expert Comment

by:Hairbrush
ID: 35234102
SharePoint Designer 2007 is a free download (http://www.microsoft.com/downloads/en/details.aspx?FamilyID=baa3ad86-bfc1-4bd4-9812-d9e710d44f42&displaylang=en)

You could use Nintex to create a similar workflow, if you prefer.
0
 

Author Comment

by:neenavishwakarma
ID: 35234295
yes i know SharePoint Designer 2007 is free now but they are already in process...
i will try with Nintex.  thanks
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question