think of the problem in small steps.

so, you know what data you need to manipulate: TABLE1

you know what table you want to UPDATE: TABLE2

I always like to see if I can ONLY create a select statement that can get me ALL of the data I need. If I can do that, then it is a good starting point for me.

sounds like you need a procedure and function in order to manipulate and pass all this data. Your explaination of the tables and fields is a bit confusing so it is hard to give you more detail that this.

remember: start small. if you accomplish 3 small items of your procedure, then you are probably a good way to the answer.

Also - think about creating a temporary table with the fields you will need to insert into TABLE2.

- magnus