Problem with UPDATE sql command

[Itchyo]

I'm trying to update a some fields which include a primary key in a table of my database which has a many to one relationship with another field of a different table.

So i'm guessing i need to update both of the primary keys at the same time.
I'm using
sql = " INSERT INTO MenuOrder (OrderID, Dish, Quantity) VALUES ('" & orderID & "', '" & dishname & "', '" & quantity & "')
AND INSERT INTO OrderPrice
(OrderID, Total Price, MonthID) VALUES ('" & orderID & "', '" & TPrice & "', '" & monthnow & "');"

I get this error:
Missing semicolon ( at end of SQL statement.

Any ideas?
Thanks in advance

 

[jmcilhinney]

You don't use AND to join multiple statements. AND is for joining multiple conditions. Multiple statements are separated by semicolons, as the error message suggests.

 

[cjard]

i'm trying to update

so i'm guessing i need to update

sql = " insert into menuorder ...
insert into orderprice

? ?