Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 367
  • Last Modified:

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

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
neenavishwakarma
Asked:
neenavishwakarma
  • 3
  • 3
1 Solution
 
HairbrushCommented:
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
 
neenavishwakarmaAuthor Commented:
no i have not done through workflow...how its possible?
0
 
HairbrushCommented:
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
neenavishwakarmaAuthor Commented:
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
 
HairbrushCommented:
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
 
neenavishwakarmaAuthor Commented:
yes i know SharePoint Designer 2007 is free now but they are already in process...
i will try with Nintex.  thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now