Hi!
I'm designing a product database.
1. Feed - this is linked to a CSV so can't change anything really
2. Products
3. Products_Feed - links 1 and 2. Multiple suppliers for stock so this basically says OurCode | SupplierCode
Then there are tables for Category, Manufacturer and Supplier. Related to the ones above.
I've got a Discounts table, where you choose Category, Manufacturer and Supplier and assign a discount percentage. So only products that match all 3 have the percentage. Does that make sense so far?
I'm stumped on how to get this last table integrated properly! I don't mind looking myself, but not even sure what to look for...
I'm designing a product database.
1. Feed - this is linked to a CSV so can't change anything really
2. Products
3. Products_Feed - links 1 and 2. Multiple suppliers for stock so this basically says OurCode | SupplierCode
Then there are tables for Category, Manufacturer and Supplier. Related to the ones above.
I've got a Discounts table, where you choose Category, Manufacturer and Supplier and assign a discount percentage. So only products that match all 3 have the percentage. Does that make sense so far?
I'm stumped on how to get this last table integrated properly! I don't mind looking myself, but not even sure what to look for...