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.
Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.