[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 363
  • 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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