Copying field values from table "A" to table "B"

[Guest]

I am trying to find a way to copy a field value from table "A" to a field
in table "B". I realize that this causes duplicate entries but it is reqired
because at a later date I need to be able the change the field value of table
"A" and not have it affect the value already copied in table "B". Thank u in
advance for any help.

 

[Tim Ferguson]

I am trying to find a way to copy a field value from table "A" to a
field in table "B".

update tableB
set somefield = dlookup("otherfield","tableA","otherkey=value")
where somekey=somevalue


If you provide more precise information, we may be able to provide more
relevant pointers.

B wishes


Tim F