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.

Signature
Scott McCoy
Tim Ferguson - 27 Sep 2005 18:49 GMT
> 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