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.