I need to do update two tables from one save button on a Win form.
I understand I cannot update two tables in one query.
I understand I must use two updates.
I do not know HOW to do two updates :^)
Do I run two UPDATE statements one right after another?
Seems I can use the same variable to fill matching data type columns in the two tables even though the table field names are different (I.e. Use variable strCompany for Company Name, in db one as CmpNm, and table2 in the CName field.
And how does that affect the code around each statement?
[Editorial (gripe) comment: I searched for "Update Two Tables". Every answer on this site says you can't in one query and you must use two UPDATE statements. NONE tell HOW, and then all of them give points and an "Accepted Solution" to NON-Solution answers! Perhaps if the Accepted Solution title was reserved for "solutions"...].
Start Free Trial
