How do I set up a workflow that copies data from one list to another within Sharepoint design

Hi

(I am running MS office sharepoint designer 2007 trial. Full version is on the way. Windows sharepoint services 2 WSS is on the server)

I am having a nightmare with sharepoint. I am using lists and workflows to set up a new starter process for HR and IT on our intranet. As you may tell from my (possibly daft) question I have only just started using it. I have ebooks and other resources at hand, but they aren't that great. I would be greatful for any help with this

What I am trying to do:

-I have set up a workflow that starts when a new item is added to list A (which I want)
-This workflow should take 3 bits of data from list A (3 seperate fields) and create a list item in list B and then update that same data into fields in list B

e.g.

LIST A has 3 columns
(key: column name - data in column)

col1 - A
col2 - B
col3 - C

LIST B has 3 columns
(key: column name - data in column)

col4 -
col5 -
col6 -

The workflow will trigger when a new item is created and will creaste a new entry in List B, as well as putting "A" in col4, "B" in col5 and "C" in col6.


Final questions

1. Am I wrong trying to do this with lists? Should I be getting infopath and using it as a form with infopath as my XML editor? Is it at all possible?
2. I thought for a second that I set up list B wrong. Should I be adding the columns from list A to the settings of list B? I couldnt work out how to do this - but it would make sense to me to do that, as it is clear you are taking data from the same field, except this field sits in another list?


ANY help would be much appreciatedStart Free Trial