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
344 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
  • 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

813 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now