Retrieving Field when ginving field No.

Hi Everybody,

Is anybody aware of the possibility to retrieve the field when giving the fieldnumber as integer ?

Problem is as follows : I hav a table with x fields : NameID, No1, No2, No3, ... Noxx.

I would like to transform this to a table with only NameID & No as fields, but with a combined Key on these fields.

Is it really necessary to write 50 times the same code again, and only change my No1 --> No2, or does anybody have a solution where I can solve this in only 1 loop (perhaps with some help of the VTable 'Field' ???

Thanks,

scOOB