I have this issue:
to simplify -
I have 5 orders I have 5 items that have varying prices and I have 5 customers. Not all customers sell these items. I also have different shipping addresses and customer contacts based on order numbers. Users can update pricing, contacts and shipping info.
I want a way for the user to update contact info as a group or pricing individually. I actually have 200k + rows of data.
| Orders | Items | price | customers | contact | Ship Contact | shipto |
| 111 | a | 0.2 | Shop | Bill A | Zach J | 125 Main |
| 111 | b | 1 | Shop | Bill A | Zach J | 125 Main |
| 111 | c | 0.05 | Shop | Bill A | Zach J | 125 Main |
| 111 | d | 1 | Shop | Bill A | Zach J | 125 Main |
| 111 | e | 0.05 | Shop | Bill A | Zach J | 125 Main |
| 222 | d | 0.9 | Shop | Bob S | Carol F | 126 Main |
| 222 | e | 1.85 | Shop | Bob S | Carol F | 126 Main |
| 333 | a | 0.03 | Shop | Sue T | Sam V | 128 Main |
| 333 | e | 9.45 | Shop | Sue T | Sam V | 129 Main |
Example for order number 111
Change contact 'Bill A' to 'William G' And shipto to '345 Center' (in all columns at one time) and price for item d to .90
What is the best way to achieve this?
Any help is appreciated