Looping code

[vipersmind]

I am trying to append record from one tables to another... sounds easy but there is a catch.

The 1st table tblTexuralCode is structured:

[B]HOLE	FROM	TO	Mj1	Mj2	Mj3	Mj4	Mj5[/B]
Test	0	1	AB				
Test	1	2	AC	AR			
Test	2	3	AS	AV	AB		
Test	3	4		AB		AV	
Test	4	5	AV	AC

the new table tblTexturalNew is structured:

[B]HoldeID	From	To	AB	AC	AR	AS	AV[/B]
Test	0	1					
Test	1	2					
Test	2	3					
Test	3	4					
Test	4	5

As you can see the values in tblTexuralCode are the same as the field names in tblTexturalNew.
I wish to assign a number value to each code in tblTexuralCode (depending on its position in the table) and append it to the field with the same name ;where the From, To, HoleID are equal in both tables.
There is more than one hole in the tblTexuralCode

Hope this is clear, seems messy to explain???

 

[Mile-O]

Can you please explain what the fields are, why you have a repeating group as field names, and what it's all supposed to be? Currently, it just seems cryptic.