Replace Field Contents

Hi All,

I am trying to move data from one table to another, and I thought the
quickest way of doing this would be to make new fields in the new
table and use the "Replace Field Contents" option. However that option
doesn't seem to work when updating information from one table to
another.

So 2 questions.

a) Does anyone know how to make this feature work going from table to
table?
b) Does anyone know a quick and easy way to move fields from one table
to another?

Thanks so much!
Tessa

Re: Replace Field Contents

In article <1192225520.401344.244860@q3g2000prf.googlegroups.com>, TLR
wrote:

> Hi All,
>
> I am trying to move data from one table to another, and I thought the
> quickest way of doing this would be to make new fields in the new
> table and use the "Replace Field Contents" option. However that option
> doesn't seem to work when updating information from one table to
> another.
>
> So 2 questions.
>
> a) Does anyone know how to make this feature work going from table to
> table?
> b) Does anyone know a quick and easy way to move fields from one table
> to another?
>
> Thanks so much!
> Tessa

If you mean you're trying to move data from one table into existing
records in another table, then you'll probably have to script it using
a relationship to connect the records in the target table with their
appropriate record(s) in the source table.

If you simply trying to move data from one table to another as new
records, then you can just import them.

Either way, you'll have to create the appropriate fields first.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Re: Replace Field Contents

In article <1192225520.401344.244860@q3g2000prf.googlegroups.com>,
TLR wrote:

> Hi All,
>
> I am trying to move data from one table to another, and I thought the
> quickest way of doing this would be to make new fields in the new
> table and use the "Replace Field Contents" option. However that option
> doesn't seem to work when updating information from one table to
> another.
>
> So 2 questions.
>
> a) Does anyone know how to make this feature work going from table to
> table?
> b) Does anyone know a quick and easy way to move fields from one table
> to another?
>
> Thanks so much!
> Tessa

Either import the data from one table to the other

or

If the records exist already in the second table, define a relationship
between the second table and the first, and then you can use the Replace
Field Contents to cause replacement by calculation from the related
first table.

--
For email, change to
Bill Collins