Update Query to multiple tables

[Gregory23]

Hi all,



I would like to check if there is a way to update two tables from one source

Also there are multiple fields to be updated, is it possible to update only the ones which have value in them ?

In the below table Proforma invoice and order form descriptions need to update based on the material number


The table in the center contains all the materials with description



Thank you

[CJ_London]

your data isn't normalised - it is set up like a spreadsheet so probably not in one query. At best you will need multiple queries, but depends on what you want to update.

What is it you want to update in each table?

[Gregory23]

I want to update the description fields

The common reference is the material but as far as I checked the material joined to multiple fields cannot update the description

below picture

[CJ_London]

You can't do it like that - you will need one query for each material and each table. so if each table has 20 materials, that means 40 queries.

As previously stated, your data is not normalised - if it was, you would not need to update anything.

A normalised invoice would usually consist of a minimum of two tables, one containing invoice header/footer data and one containing invoice line information. For each invoice header record there would be many invoice line records, one for each material - and the material data would just be the ID - which would then be linked to your materials table to find the description.