D
Dennis
I have a table from another program called Black and I
want to use the data that is updated daily in this table
to update to my table called White. The White table has a
PK and the Black table, from another program, does not
have a PK. As a result, some of the data is duplicated in
the Black table. By appending the Black table to my White
table I successfully get any new records. The problem I am
having is when some data is changed in the Black table
(not the PK field) I do not know how to update the changes
of the existing records in the White table? I tried the
update query and hosed the Black table (thank god for
backups) and updated the field with the word White
thinking "Update To" meant update this field to the same
field in the White table. NOT!
Do I use Append somehow?
Thanks,
Dennis
want to use the data that is updated daily in this table
to update to my table called White. The White table has a
PK and the Black table, from another program, does not
have a PK. As a result, some of the data is duplicated in
the Black table. By appending the Black table to my White
table I successfully get any new records. The problem I am
having is when some data is changed in the Black table
(not the PK field) I do not know how to update the changes
of the existing records in the White table? I tried the
update query and hosed the Black table (thank god for
backups) and updated the field with the word White
thinking "Update To" meant update this field to the same
field in the White table. NOT!
Do I use Append somehow?
Thanks,
Dennis