I've tried searching but cant figure out the best setup. Any help would be appreciated.
Lets say I have 5 product SKUs. And I have 10 customers. Each customer is assigned specific SKUs. Example, customer 1 is assigned SKUs A and B. Customer 2 only assigned SKU A. Customer 3 assigned all SKUs A to E. An order form would display only their assigned SKUs.
I understand creating tables for customers and table for SKUs. But how would I assign the SKUs to the customer and create an order form that displays those assigned?
User | Count |
---|---|
36 | |
8 | |
3 | |
2 | |
2 |