michaels
New member
- Local time
- Today, 09:44
- Joined
- Mar 29, 2021
- Messages
- 3
We have a table of customers and per each customer there are 68 columns that represent each manufacturer a bit like the picture below.
66N,ABF,ADI etc each represent the manufacturer and the no of orders by customer for that particular manufacturer.
We have another table called Manufacturers Like so
We have a column in table 1 called Maxid. We want this value to be updated with the maximum id from table 2 based on what the customer had ordered.
For example Customerid has 66N and AMJ. If 66N = 0 and AMJ = 1 then the Maxid value will be 1.
I hope someone can help please with this
66N,ABF,ADI etc each represent the manufacturer and the no of orders by customer for that particular manufacturer.
We have another table called Manufacturers Like so
We have a column in table 1 called Maxid. We want this value to be updated with the maximum id from table 2 based on what the customer had ordered.
For example Customerid has 66N and AMJ. If 66N = 0 and AMJ = 1 then the Maxid value will be 1.
I hope someone can help please with this
