I’ve created an accdb with prospects and merchandise tables.
Now, I need to know learn how to retailer the gross sales order particulars within the Gross sales desk, WHEN every sale has a number of merchandise, every with completely different amount and value.
Like Order S01 -> Buyer X -> Merchandise a, b, c -> qty 1, 2, 3 -> value 100, 200, 300
I’m planning to insert and replace gross sales particulars from my excel sheet.
- As my order quantity would be the distinctive main key, I believe its illogical to repeat order numbers for every product.
S01 | X | a | 1 | 100
S01 | X | b | 2 | 200
- At the moment, I’ve carried out this as comma-separated values in a area, but it surely appears it’s not a superb apply to retailer like this. It entails a number of pointless scripting to unwrap and wrap the information and in no way intuitive.
S01 | X | a,b,c | 1,2,3 | 100,200,300
- I can not create a separate desk for every product to retailer the gross sales and buy knowledge(if that is known as normalization). Too many tables, not good apply.
S01| X | 1 | 100
S01| X | 2 | 200
So, whats probably the most optimized and intuitive solution to retailer such knowledge and retrieve it.