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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
I am trying to find a way to copy a field value from table "A" to a
field in table "B".
Click to expand...

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
 
Back
Top