Hi All,

I want to update Consultant table fields by entering data into Invoice.

In Consultant table I want to update " First Name, Last Name, Description " from Invoice table.. I have defined ConsultantID as Primary Key in Consultant Table.

We entre data into Invoice table Like First Name, Last Name, Description etc, I want to update only " First Name, Last Name, Description" in Consultant table by running simple update query.

For Invoice table I have Primary Key is InvoiceID.

Can some please write a simple SQL query for me. I need this for MS Access.


Eigen Vectors.