Copy ID column from List A to TASK List B using Workflow in SPD 2007

I have created approval workflow in SPD 2007.

Step 1) User submit the form --> Workflow setup on create a new item on Request Form Step 2) Workflow kickoff and create a tasks and assign to various teams. Step 3) User fillout the feedback on assigned task and submit

Requirement. : When User submit the form then form generate it's own ID (interanl id). Workflow generate the new tasks then it assign interal ID to each tasks.

In Task list. I would like to add column that represent the Original Request ID from Request Form. So, in my report, I can show which requests are pending or so..

Example,

Customer Requests List

Request ID Customer Name Customer Phone# etc.... 222 ABC Company 111-222-3333

Workflow Tasks

Request ID Title Assigned To Status 222 Approval to add new customer John Smith Pending

I would like to populate Request ID column in TASK fr开发者_开发技巧om Customer Request List [ Column ID ] without writing code. Is it possible ?

Something link this...

Task List ID Assign To Link Request ID 1 Sales ABC (Hyperlink) 100 2 Marketing ABC (Hyperlink) 100 3 Audit ABC (Hyperlink) 100

I would apprecaite your help.

---

It sounds like you already answered your own question. In your workflow, add another step to update each task's RequestID field to be Current Item -> ID.

---

If i have understood you correctly (which i may not have so apologies in advanced if so) you could do this:

• Create The Task List in the TASK LIST B with a lookup field (linked to TASK LIST A) in the task that you set to the ID of the the current item
• When you have created the item you will get the ID in a variable of the list item you have created - set a lookup field (linked to TASK LIST B) in TASK LIST A to the 'create' variable from creating the TASK LIST B item

This will give you a link between each task list item within the task list item (because of the lookup fields' functionality) and you will have made a link between the two...

Hope this makes sense and helps out in some way...