Reading from one table and to another - string problem

[GLT]

Hi,

I have two record sets open - i am trying to take data from the first record
set and add it to another.

In my first recordset, there are two columns (for example):

Col 1 Col 2

JOB JOB15XY
JOBNAME STRDMTTYS
JOBID 134565


Col 1 repeats many times over - its a waste of space having JOB, JOBNAME and
JOBID repeated somany times.

What I am tring to do is use the values in col 1 as headings in a new table,
and copy the details of col2 - so the recordset will look like this:

JOB JOBNAME JOBID
JOB15XY STRDMTTYS 134565

The code i am trying to use is as follows:

rst1.AddNew
rst1![DateStamp] = strDate
rst1![FileNo] = strFileNo
rst1!strReadFeild1 = strFeild2 <----- Item not found error

strReadFeild1 is a string varible which reads col 1 value from the first
recordset.
If I try and use the string in second recordset, an Item Not Found Error is
returned.

Does anyone know how to get around this problem?

Cheers,
GLT.

 

[Fred]

I noticed that nobody answered.

If I may make a suggestion. You really didn't say much about what you are
tyring to do. Instead you mostly talked about how you are trying to do it.

Once you work on defining the problem you may end deciding that you have
fundamental table design problems......that was my gut feel from the glimpse
that you gave us.