Table to Table Update
Here's my problem
Table "a" has three fields Seqno, Name, Phone.
Table "b" has three fields Seqno, Name, Phone.
I'm trying to link the tables based on "Seqno" (Relationship).
Than replace "a" Name and Phone with "b" Name and Phone.
I'm from dBase and tring to get the feel of Access 2007. With dBase it would have been a relationship followed by a replace.
Hope for some help.