Hi
I have 1 table with fields Code,Name. Records are like this
A01 1000
A02 2000 and so on
This Code will be fields in another table . Another table will be like this
ID A01 A02
1 1000 2000
I want the values of rows from 1 table to their corresponding fields in another table to get updated . How this can be done
Thanks