Help on updating multiple cells but sharing the same ID

[grw]

Hi,


New to this forum so please feel free to move this request to the correct group. I have a database of items and each item is made from several components. I'm trying to find a way to change the location of the components without having to do them individually.



So for example, I want to change the location of all the components of item A from "Z" to "Q" and was wondering if there is a way of doing this via a form and en-mass rather than one at a time?

[pbaldy]

Sure an update query:

https://support.office.com/en-us/art...9-35e5ee1e0514

[NoellaG]

Hi,

clearly 1 item can have many components but is stored in 1 place. Normalize your structure and split the table into tblItems and tblItemComponents and you will have no problems on updating. If you have to update an item in several places it's a sure sign that the database structure is incorrect.